Re: why ORDER BY works wrong in pg7.3.4?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why ORDER BY works wrong in pg7.3.4?
Дата
Msg-id 8928.1069680836@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: why ORDER BY works wrong in pg7.3.4?  (igor <root@osb368.nnov.ru>)
Список pgsql-general
igor <root@osb368.nnov.ru> writes:
> Thank u for hint it really helped me - I made initdb with new lc-ctype
> and lc-collate
> settings : ru_RU:UTF8.
> But im still  having one question - some functions - lower() and upper()
> doesnt work properly . what im doing wrong?

We don't have any support for upper() and lower() in multibyte character
encodings, such as UTF8.  You need to use a single-byte encoding (and a
locale setting to match, of course).

Yeah, I know this sucks :-(.  I think Peter Eisentraut is looking into
fixing it for 7.5.

            regards, tom lane

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

Предыдущее
От: "Claudio Lapidus"
Дата:
Сообщение: Re: rounding timestamps
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: Export CSV from psql