Re: Problem with Chinese characters

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Mimi Siu
> Sent: 04 November 2005 09:56
> To: pgsql-odbc(at)postgresql(dot)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.