Обсуждение: UPPER / lower

Поиск
Список
Период
Сортировка

UPPER / lower

От
Юрий Морозов
Дата:
Hi!
I've installed Postgres 7.3 on my OpenBSD and created database workspace with a string like
initdb --encoding=WIN --lc-collate=ru_RU.CP1251 --lc-ctype=ru_RU.CP1251 ...
But then I faced with a trouble: the UPPER and LOWER functions do not
work correctly with Russian symbols. Well, actually, they don't
work at all :(
However, ORDER BY works just perfect.

Could you tell me if there is a way to reconfigure the database in
order to make possible uppercase/lowercase convertions?

--
Best regards,
Morozov Yuriy.