Unicode sorting problem

From: David Jorjoliani <djorj(at)nilc(dot)org(dot)ge>
To: pgsql-general(at)postgresql(dot)org
Subject: Unicode sorting problem
Date: 2006-07-31 17:34:08
Message-ID: 44CE3F10.8020700@nilc.org.ge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas Horst 2006-07-31 17:40:11 Re: Error in PostgreSQL query with psycopg
Previous Message Joshua D. Drake 2006-07-31 17:33:15 Re: Error in PostgreSQL query with psycopg