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

2004-12-22 Thread Hannu Krosing
Ühel kenal päeval (laupäev, 18. detsember 2004, 02:41+0100), kirjutas Palle Girgensohn: --On torsdag, december 16, 2004 09.20.50 +0100 Peter Eisentraut [EMAIL PROTECTED] wrote: Palle Girgensohn wrote: Not on FreeBSD, since collation is not implemented in unicode locales. One way would

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

2004-12-17 Thread Palle Girgensohn
--On torsdag, december 16, 2004 09.20.50 +0100 Peter Eisentraut [EMAIL PROTECTED] 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

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

2004-12-16 Thread Peter Eisentraut
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

[HACKERS] getting 'order by' working with unicode locale? ICU?

2004-12-15 Thread Palle Girgensohn
Hi! I'm using Postgresql on FreeBSD, and would like to get order by to work with unicode. The OS does have collation implemented for unicode (UTF-8) locales. Some freebsd people point me towards IBM:s ICU kit. How much effort would be required to get postgresql to sort properly, mainly using

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

2004-12-15 Thread Tom Lane
Palle Girgensohn [EMAIL PROTECTED] writes: I'm using Postgresql on FreeBSD, and would like to get order by to work with unicode. What makes you think it doesn't? Use the right locale and you're set. regards, tom lane ---(end of

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

2004-12-15 Thread Palle Girgensohn
--On onsdag, december 15, 2004 23.21.13 -0500 Tom Lane [EMAIL PROTECTED] wrote: Palle Girgensohn [EMAIL PROTECTED] writes: I'm using Postgresql on FreeBSD, and would like to get order by to work with unicode. What makes you think it doesn't? Use the right locale and you're set. Not on FreeBSD,