Re: UNICODE/UTF-8 on win32

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: mha(at)sollentuna(dot)net, pgsql-hackers-win32(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNICODE/UTF-8 on win32
Date: 2005-01-03 00:48:02
Message-ID: 20050103.094802.48401513.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

> "Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> > I didn't consider the C locale. Do you know for a fact that it works
> > there on win32 as well, or is that an assumption?
>
> It should work. The only use of strcoll() in the backend is in
> varstr_cmp which uses strncmp() instead for C locale. Lack of
> working upper/lower is hardly a fatal objection, considering that
> we never had that for UTF8 before 8.0 anyway. But you do have to
> have working varstr_cmp.
>
> > It would be good to have some way of detecting if it worked or not at
> > the time of creation of the database. But I have no idea on how to do
> > that in a reasonable way.
>
> At this point I'd say that any combination of UTF8 encoding with a non
> C/POSIX locale probably isn't going to work on Windows. Tatsuo, do you
> know of other cases that will work?

No. I think C is the only working locale.
--
Tatsuo Ishii

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2005-01-03 00:48:51 Re: UNICODE/UTF-8 on win32
Previous Message Juan Espino 2005-01-03 00:45:02 Label Security

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Tatsuo Ishii 2005-01-03 00:48:51 Re: UNICODE/UTF-8 on win32
Previous Message Tom Lane 2005-01-02 17:45:33 Re: UNICODE/UTF-8 on win32