Re: getting 'order by' working with unicode locale? ICU?

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема Re: getting 'order by' working with unicode locale? ICU?
Дата
Msg-id 93E9A08CD90D8DFF6E9E2FB8@palle.girgensohn.se
обсуждение исходный текст
Ответ на Re: getting 'order by' working with unicode locale? ICU?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: getting 'order by' working with unicode locale? ICU?  (Hannu Krosing <hannu@tm.ee>)
Список 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 по дате отправления:

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: pgmemcache 1.0rc1...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Call for port reports