Re: [pgadmin-hackers] Multibyte ODBC - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: [pgadmin-hackers] Multibyte ODBC
Date
Msg-id 3C7EC22F.2ACF01B7@tpf.co.jp
Whole thread Raw
In response to Re: [pgadmin-hackers] Multibyte ODBC  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-odbc
Dave Page wrote:
>
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> >
> > Dave Page wrote:
> > >
> > > 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.
>
> Please excuse my ignorance on this one Hiroshi, but just about everything I
> read is getting me more confused :-(
>
> I assume by locale, in this context you mean Windows local - what it calls
> it's regional settings?

Yes you have to localize your environment(application) to
use a specific encoding like SJIS.

> If so, I think this is still a problem because what
> we are trying to achieve (at least in Access as it seems VB won't do it) is
> display of multiple languages at once. For example, in a fictional case
> someone may have a Unicode database that may contain data in Japanese
> (UTF-8), French, English and maybe other languages (Jean-Michel may even be
> in this situation now).
>
> Access can do this quite happily with it's native tables (with no locale
> changes),

Windows applications are very happy as long as they
live in the Windows world because Windows(NT/2000/XP)
is a world of Unicode(UCS-2).

> it's just the linked PostgreSQL tables that don't want to work
> :-(.

I hope Unicode(UCS-2) support for our ODBC driver would
solve it though I couldn't guarantee when it would be
ready.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Steve Wranovsky
Date:
Subject: PostgreSQL 7.2 RedHat ODBC RPM Problem
Next
From: Hiroshi Inoue
Date:
Subject: Re: [pgadmin-hackers] Multibyte ODBC