Re: [GENERAL] PostgreSQL, Mac OS X and locales

2005-11-02 Thread Guido Neitzer
On 02.11.2005, at 11:47 Uhr, Martijn van Oosterhout wrote: Ah you noticed that. Yes, many of the UTF-8 locales in FreeBSD simply point to the ASCII versions which doesn't exactly work very well. Right. Only another FreeBSD system, these files are not portable. However, the source files for

Re: [GENERAL] PostgreSQL, Mac OS X and locales

2005-11-02 Thread Martijn van Oosterhout
On Wed, Nov 02, 2005 at 07:27:49AM +0100, Guido Neitzer wrote: > The LC_COLLATE for this locale is a link pointing to "../la_LN.US- > ASCII/LC_COLLATE". This is why I don't think they paid much attention > to the correct sort order of umlauts. Ah you noticed that. Yes, many of the UTF-8 locales

Re: [GENERAL] PostgreSQL, Mac OS X and locales

2005-11-01 Thread Guido Neitzer
On 01.11.2005, at 23:24 Uhr, Martijn van Oosterhout wrote: PostgreSQL should get the same results as the command-line sort for the same values of LC_COLLATE. However, the value is fixed at initdb time so maybe that's what's confusing you. Yes, it gets the same results as sort. I have tried

Re: [GENERAL] PostgreSQL, Mac OS X and locales

2005-11-01 Thread Martijn van Oosterhout
On Tue, Nov 01, 2005 at 10:56:02PM +0100, Guido Neitzer wrote: > Hi. > > I have a problem with the use of PostgreSQL on Mac OS X (10.4.x) and > selects with "order by". When there are german umlauts in the column > which is used to order, the sorted result is wrong. PostgreSQL should get the