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

From: Kris Jurka <books(at)ejurka(dot)com>
To: Eric Tan <neltan2002(at)yahoo(dot)com(dot)hk>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: How to insert Chinese (big5) through JDBC?
Date: 2003-07-31 08:10:59
Message-ID: Pine.LNX.4.33.0307310408000.21596-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Eric Tan 2003-07-31 09:53:12 Re: How to insert Chinese (big5) through JDBC?
Previous Message Kris Jurka 2003-07-31 08:07:21 Re: unsubscribe