Re: [GENERAL] Ordering and unicode

2005-11-11 Thread Guido Neitzer
On 11.11.2005, at 9:33 Uhr, Guido Neitzer wrote: Yes, as far as I know there is no other way of changing the locale settings. Hopefully you are on Linux! If you deploy on Mac OS X or *BSD it won't work even with a change. I have to correct me: Hopefully you are not on Mac OS X. On Mac OS X,

Re: [GENERAL] Ordering and unicode

2005-11-11 Thread Guido Neitzer
On 10.11.2005, at 21:31 Uhr, Michael Schuerig wrote: My current conjecture is that I'd have to re-initialize the cluster with a utf-8 collation. Is this correct? Right now I don't have access to the machine and can't check this. Yes, as far as I know there is no other way of changing the loc

Re: [GENERAL] Ordering and unicode

2005-11-10 Thread Michael Schuerig
On Thursday 10 November 2005 21:31, Michael Schuerig wrote: > I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding, > client encoding is set to unicode, too. LC_COLLATE for the cluster is > [EMAIL PROTECTED] I noticed that that collation doesn't work for > two-byte characters, appare

[GENERAL] Ordering and unicode

2005-11-10 Thread Michael Schuerig
I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding, client encoding is set to unicode, too. LC_COLLATE for the cluster is [EMAIL PROTECTED] I noticed that that collation doesn't work for two-byte characters, apparently they are ordered bytewise. My current conjecture is that I