> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mimi Siu
> Sent: 04 November 2005 09:56
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Problem with Chinese characters
>
> Hello:
>
> I would like to use ANSI ODBC driver as my sql
> statement is already converted to UTF-8 before
> calling SQLExecute(). However, i found from the log
> file that the client encoding is BIG5 which is my
> system's locale, so the text is wrong when it is
> inserted to my UNICODE database.
>
> Can I set the client encoding to UTF8 in my DNS or
> through any ODBC functions??
In the connect settings box in the config, you can add something like:
SET client_encoding TO 'UTF8';
Regards, Dave.