Sorting Problem in UNICODE/german

Поиск
Список
Период
Сортировка
От Klaus Ita
Тема Sorting Problem in UNICODE/german
Дата
Msg-id 20050901110235.GC1479@aipc54.ai.wu-wien.ac.at
обсуждение исходный текст
Ответы Re: Sorting Problem in UNICODE/german  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi there!

I have a Problem with a DB that was created in UNICODE

* createdb -E UNICODE

and actually shows that it _is_ in UNICODE.
i was able to input data and can read it and everything is fine.
but when i want to "ORDER BY ..." it does not sort the german Umlauts at the
correct postition.

should be:
m n o ö p

and is:
ö a b c d

I have tried starting postgres with LC_ALL=de_AT.utf8@euro
locale but that did not help.

what xould i do?

regs,
klaus

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql TEMP table issue not fixed in 8.1?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sorting Problem in UNICODE/german