Unicode sorting problem
От | David Jorjoliani |
---|---|
Тема | Unicode sorting problem |
Дата | |
Msg-id | 44CE3F10.8020700@nilc.org.ge обсуждение исходный текст |
Ответы |
Re: Unicode sorting problem
|
Список | 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 по дате отправления: