Re: 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??

Thanks a lot!

--- Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:

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

__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com