Problem with encoding (lower() doesn't work) - Mailing list pgsql-general

From Vitaliyi
Subject Problem with encoding (lower() doesn't work)
Date
Msg-id 3aac340704231155g2a41053eo5092ed9eff27fd70@mail.gmail.com
Whole thread Raw
List pgsql-general
Steps :
export LANG=ru_RU.KOI8-r (locale was set properly)
initdb
createdb -E WIN tst
psql tst < tsearch2.sql
  psql tst :
  SET client_encoding to KOI8;
  create table tst (name text, v tsvector);
  insert ..
  update tst set v = to_tsvector(lower(nm));

and i've got capitalized russian text in v (vectors) :(

the select * from lower(); isnt working too

I've tried Postgres 8.1 and 8.2

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: using Postgres with Sequoia
Next
From: Matthew Hixson
Date:
Subject: change format of logging statements?