lower not working - Mailing list pgsql-admin

From Markus Bertheau
Subject lower not working
Date
Msg-id 1054205661.2469.6.camel@saphir
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Michael Mattox"
Date:
Subject: Vacuum strategies
Next
From: Bruno Wolff III
Date:
Subject: Re: Vacuum strategies