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.