Skip site navigation (1) Skip section navigation (2)

Multibyte ODBC

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'jm(dot)poure(at)freesurf(dot)fr'" <jm(dot)poure(at)freesurf(dot)fr>
Cc: 'Hiroshi Inoue' <Inoue(at)tpf(dot)co(dot)jp>,pgadmin-hackers(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: Multibyte ODBC
Date: 2002-02-27 13:24:26
Message-ID: FED2B709E3270E4B903EB0175A49BCB104763E@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-odbc
Hiroshi, please disregard my earlier email requesting a precompiled MB copy
of the driver - I found Eiji Tokuya's download.

I have now tried the following tests using my own compilation of the MB
driver and Eiji's:

1) Created a unicode database in 7.2/cygwin and loaded Jean-Michel's
Japanese test table.

2) Created a datasource, and added SET CLIENT_ENCODING='SJIS' to the connect
settings.

3) Linked the test table from Microsoft Access XP.

4) Using the Arial Unicode MS font, the data in Access looks like garbage.

5) Similar tests using the pgAdmin data grid yield the same results (as
expected 'cos it's VB).

I also copied Jean-Michel's test data into an html file so I could see what
it should look like. If I copy some Japanese chars into an Access table, it
works fine, however, if I copy them into the linked table, they get
converted to ????.

I was also getting the following message in the console:

NOTICE:  utf_to_local: could not convert UTF-8 (0xc3a9). Ignored

Any ideas anyone?

Regards, Dave.

Responses

pgsql-odbc by date

Next:From: Jean-Michel POUREDate: 2002-02-27 13:28:30
Subject: Re: Multibyte ODBC
Previous:From: Dave PageDate: 2002-02-26 15:35:35
Subject: Re: pgAdmin2 Japanese display

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2002-02-27 13:28:30
Subject: Re: Multibyte ODBC
Previous:From: Jean-Michel POUREDate: 2002-02-27 10:26:38
Subject: Re: Graphical ER Editor / Graphical Query Editor : First stages?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group