Re: Unicode is not UTF-8. was :psqlODBC-Driver Test / text fields

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Marc Herbert
> Sent: 31 March 2006 10:23
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Unicode is not UTF-8. was
> :psqlODBC-Driver Test / text fields
>
> "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
>
> >
> >> Windows XP supports ANSI, UTF-8, Unicode and Unicode Big Endian.
> >> Unfortunately (or fortunately?) Windows seems to use UTF-8 for
> >> European languages. Hiroshi can you explain that? I guess the
> >> Japanese edition of Windows XP is using pure 2 byte Unicode.
>
> > Ahh, now I do know that Windows does not fully support
> UTF-8. That's
> > the very reason why it is not supported in PostgreSQL 8.0
> on Windows,
> > and in 8.1 and above requires conversion routines that were
> added to
> > the server by Magnus Hagander to convert to UCS2(?) before
> doing any
> > sorting etc.
>
>
> Do you mean CP_UTF8 does not exist on some asian releases of Windows?

I believe the problem is that the code pages exist, but there are no
corresponding NLS files - see the notes here:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#2.6

I don't know that that actually affects us from an ODBC point of view
though - but regardless, the ODBC API uses UCS-2 as Hiroshi reminded us.

Regards, Dave.