Re: [GENERAL] Unicode sorting problem

2006-08-01 Thread Martijn van Oosterhout
On Mon, Jul 31, 2006 at 09:34:08PM +0400, David Jorjoliani wrote: > ka_GE.UTF-8 is Georgian locale. > When run sql query with "order" of "text" or "varchar" field with > Georgian unicode data inside, result is totally wrong. > Can somebody help me? Please define "wrong". What OS? What version of

[GENERAL] Unicode sorting problem

2006-08-01 Thread David Jorjoliani
Hi, I have problem with UTF-8 database sorting. Postgres initialized with: --locale=ka_GE.UTF-8 --lc-collate=ka_GE.UTF-8 "show all;" command shows: ... lc_collate | ka_GE.UTF-8 | Shows the collation order locale. lc_ctype| ka_GE.UTF-8