Thread: Multibyte 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.
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
> -----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.
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
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