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.