Re: getting 'order by' working with unicode locale? ICU? - Mailing list pgsql-hackers

From Palle Girgensohn
Subject Re: getting 'order by' working with unicode locale? ICU?
Date
Msg-id 93E9A08CD90D8DFF6E9E2FB8@palle.girgensohn.se
Whole thread Raw
In response to Re: getting 'order by' working with unicode locale? ICU?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: getting 'order by' working with unicode locale? ICU?
List pgsql-hackers

--On torsdag, december 16, 2004 09.20.50 +0100 Peter Eisentraut 
<peter_e@gmx.net> wrote:

> Palle Girgensohn wrote:
>> Not on FreeBSD, since collation is not implemented in unicode
>> locales. One way would be to implement it in the OS, of course...
>
> Try taking the locale definition files from another system and use
> localedef to build locale files for your local system.  The localedef
> source files are supposed to be portable.

As far as I understand, there is no code in FreeBSD to specify the 
collating order for multibyte locales. Would ot be easier to fix the OS or 
hack ICU into PostgreSQL?

A bit off topic: I'm still dreaming of a way to get "order by" working with 
different locales for the same database (different clients getting 
different collation depending on their locale choice). Now this is 
hardcoded at initdb time. Is there any way this could work, ever, in 
PostgreSQL, or will I have to sort client side?

Regards,
Palle



pgsql-hackers by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: pgmemcache 1.0rc1...
Next
From: Bruce Momjian
Date:
Subject: Re: Call for port reports