Обсуждение: lower not working

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

lower not working

От
Markus Bertheau
Дата:
Hi,

lower doesn't lowercase accented and cyrillic characters for me:

template1=# select lower('ÄÖÜФЫВА');
     lower
----------------
 ÄÖÜФЫВА
(1 запись)

I expected:

template1=# select lower('ÄÖÜФЫВА');
     lower
----------------
 äöüфыва
(1 запись)

I ran initdb in the right locale:

$ pg_controldata /var/lib/postgresql/data/ | grep LC
LC_COLLATE:                           ru_RU.UTF-8
LC_CTYPE:                             ru_RU.UTF-8

Why does it not work?

--
Markus Bertheau.
Berlin, Berlin.
Germany.