I am not able to get work lower and upper functions on postgresql v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux. Locale: ru_RU.KOI8-R
createdb -E UNICODE test psql test test=> SET client_encoding TO KOI8; SET test=> SELECT t FROM t1; t -------- ÐÐÐÐÐÐ tEsT (2 rows) test=> SELECT upper(t) FROM t1; upper -------- ÐÐÐÐÐÐ TEST test=> SELECT lower(t) FROM t1; lower -------- ÐÐÐÐÐÐ test (2 rows) How you can see it work perfect with latin and does not do any lower/upper with koi8. what I do wrong? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster