Re: Problem with Chinese characters

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mimi Siu
> Sent: 03 November 2005 10:03
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Problem with Chinese characters
>
> Hi:
>
> I am using psqlodbc-08-00-0102 ODBC driver on my
> Windows 2000 machine and want to insert data (with
> chinese characters) to the postgresql 8.0.3 running on
> RH9.
>
> My database is encoded as UNICODE, and my sql
> statement is already converted to UTF-8 before calling
> SQLExecute(). But I found that the coding of the
> chinese characters is not UTF-8 in the postgresql
> database. Also if I insert the record with 10 chinese
> characters, the length of the field should be 10, but
> now it is 30.
>
> It was previously work when I use the
> psqlodbc-07-02-01 driver with postgresql 7.3.

Please try the latest snapshot - 08.01.0005. It has various fixes and
can be compiled in Unicode or ANSI/Multibyte mode as the older 07.xx
drivers could (08.00.xxxx was Unicode only).

Regards, Dave