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