Thread: Re: [ODBC] Multibyte ODBC

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> Sent: 01 March 2002 06:08
> To: Dave Page
> Cc: 'jm.poure@freesurf.fr'; pgadmin-hackers@postgresql.org;
> pgsql-odbc@postgresql.org
> Subject: Re: [pgadmin-hackers] [ODBC] Multibyte ODBC
>
>
> Dave Page wrote:
> >
> > The psqlODBC driver doesn't export *any* W functions in it's .def.
> >
> > So, could this be the problem? Access XP wants Unicode, but
> the driver
> > is only providing it with UTF-8 encoded data (ie, multibyte data
> > encoded into ASCII)?
>
> OK I put a trial driver on http://w2422.nsk.ne.jp/~inoue/
> (psqlodbc30W.zip). Note that it's another driver and you have
> to register the driver newly. The name of the dll is
> psqlodbc30.dll. Create new DSNs for the driver and test it.
> Also note that you have to set the client_encoding to UTF-8
> using the Connect Settings option.

:-) That does the trick, thanks!! I can view and update Japanese & English
text and it works perfectly (well, it looks the same before & after :-) )
with no client encoding, with client encoding = UNICODE and with client
encoding = UTF-8.

Now to figure out how to get some VB controls to work... :-(

Regards, Dave.

Dave Page wrote:
>
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> >
> > OK I put a trial driver on http://w2422.nsk.ne.jp/~inoue/
> > (psqlodbc30W.zip). Note that it's another driver and you have
> > to register the driver newly. The name of the dll is
> > psqlodbc30.dll. Create new DSNs for the driver and test it.
> > Also note that you have to set the client_encoding to UTF-8
> > using the Connect Settings option.
>
> :-) That does the trick, thanks!! I can view and update Japanese & English
> text and it works perfectly (well, it looks the same before & after :-) )
> with no client encoding, with client encoding = UNICODE and with client
> encoding = UTF-8.

Oh yes, you don't have to set the clent_encoding if
the database(server) encoding is UTF-8.

regards,
Hiroshi Inoue

Dave Page wrote:
>
> > OK I put a trial driver on http://w2422.nsk.ne.jp/~inoue/
> > (psqlodbc30W.zip). Note that it's another driver and you have
> > to register the driver newly. The name of the dll is
> > psqlodbc30.dll. Create new DSNs for the driver and test it.
> > Also note that you have to set the client_encoding to UTF-8
> > using the Connect Settings option.
>
> :-) That does the trick, thanks!! I can view and update Japanese & English
> text and it works perfectly (well, it looks the same before & after :-) )
> with no client encoding, with client encoding = UNICODE and with client
> encoding = UTF-8.

Please replace the driver with the newest one.
It had a pretty serious bug.
Great thanks to Eiji Tokuya for his useful debugging.

regards,
Hiroshi Inoue