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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to