Search Postgresql Archives

Unicode sorting problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux