Unicode sorting problem - Mailing list pgsql-general

From David Jorjoliani
Subject Unicode sorting problem
Date
Msg-id 44CE3F10.8020700@nilc.org.ge
Whole thread Raw
Responses Re: Unicode sorting problem  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
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
| Shows the character classification and case conversion locale.
 lc_messages                     | ka_GE.UTF-8
| Sets the language in which messages are displayed.
 lc_monetary                     | ka_GE.UTF-8
| Sets the locale for formatting monetary amounts.
 lc_numeric                      | ka_GE.UTF-8
| Sets the locale for formatting numbers.
 lc_time                         | ka_GE.UTF-8
| Sets the locale for form
...

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?
Thanks,
David Jorjoliani


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Triggers in Postgres
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Unicode sorting problem