Re: How to insert Chinese (big5) through JDBC?

On Thu, 31 Jul 2003, [big5] Eric Tan wrote:

> Hi,
>   I can now insert Chinese!!
>   I'm now using EUC_TW as the database encoding.
>   However, the default client encoding is now EUC_TW. (that's why I
> cannot insert Chinese). I have to exe "set client_encoding to 'Big5';"
> when inserting and selecting.
>
>   Can I set Big5 as the default client_encoding ?
>

You can make it the default for the database or for the user you are
connecting as.  Try running

ALTER DATABASE <databasename> SET client_enconding TO big5;

or

ALTER USER <username> SET client_encoding TO big5;

Kris Jurka



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match