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
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 |