Thread: Multibyte ODBC

Multibyte ODBC

From
Dave Page
Date:
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.

Re: Multibyte ODBC

From
Jean-Michel POURE
Date:
Le Mercredi 27 Février 2002 14:24, Dave Page a écrit :
> 2) Created a datasource, and added SET CLIENT_ENCODING='SJIS' to the
> connect settings.

If you are using a full Unicode chain (PostgreSQL, ODBC, AccessXP), try SET
CLIENT_ENCODING='UNICODE', otherwise this will not work. If it does not work,
try again with the old ODBC driver.

UTF-8 chains are simple ASCII chains which should pass through the usual odbc
driver.

Cheers,
Jean-Michel

Re: Multibyte ODBC

From
Dave Page
Date:

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 27 February 2002 13:29
> To: Dave Page
> Cc: 'Hiroshi Inoue'; pgadmin-hackers@postgresql.org;
> pgsql-odbc@postgresql.org
> Subject: Re: Multibyte ODBC
>
>
> Le Mercredi 27 Février 2002 14:24, Dave Page a écrit :
> > 2) Created a datasource, and added SET
> CLIENT_ENCODING='SJIS' to the
> > connect settings.
>
> If you are using a full Unicode chain (PostgreSQL, ODBC,
> AccessXP), try SET
> CLIENT_ENCODING='UNICODE', otherwise this will not work. If
> it does not work,
> try again with the old ODBC driver.

Nope, no difference.

> UTF-8 chains are simple ASCII chains which should pass
> through the usual odbc
> driver.

Yes, I think they are (passing through that is), they're just not being
interpreted correctly by the client (I guess).

Regards, Dave.

Re: Multibyte ODBC

From
Hiroshi Inoue
Date:
Dave Page wrote:
>
> 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.

You need to set the *Japanese* locale if you'd like to
display Japanese using SJIS.

regards,
Hiroshi Inoue

Re: Multibyte ODBC

From
Jean-Michel POURE
Date:
Dear Dave,

UTF-8 / AccessXP Japanese problem :

- Try import the linked dobc table into an Access table. Can you display the
Japanese glyphs? Did you write you could also display the glyphs when
copying/pasting into a table?

- If AccessXP can display the data from its tables and not from ODBC, it may
be because some "header" information are needed in the ODBC stream (example :
invisible characters at the beginning of file).

This idea comes to me because in HTML, you need to tell the browser to switch
to UTF-8 display (in header information), otherwize IE5 is not smart enought
to understand the ASCII characters are plain UTF-8. Maybe AccessXP is like
IE5... But I may be wrong...

Can you display the glyphs now?

Cheers,
Jean-Michel