Skip site navigation (1) Skip section navigation (2)

Re: Multibyte ODBC

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'jm(dot)poure(at)freesurf(dot)fr'" <jm(dot)poure(at)freesurf(dot)fr>,pgadmin-hackers(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Multibyte ODBC
Date: 2002-02-28 23:50:07
Message-ID: 3C7EC22F.2ACF01B7@tpf.co.jp (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-odbc
Dave Page wrote:
> 
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)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

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-03-01 06:08:18
Subject: Re: [ODBC] Multibyte ODBC
Previous:From: RobinsonDate: 2002-02-28 20:28:25
Subject: CLOB data type

pgadmin-hackers by date

Next:From: Hiroshi InoueDate: 2002-03-01 06:08:18
Subject: Re: [ODBC] Multibyte ODBC
Previous:From: Dave PageDate: 2002-02-28 13:36:45
Subject: Re: Set Default

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group