Problem with encoding (lower() doesn't work)

From: Vitaliyi <imgrey(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with encoding (lower() doesn't work)
Date: 2007-04-23 18:55:10
Message-ID: 3aac340704231155g2a41053eo5092ed9eff27fd70@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Hixson 2007-04-23 19:29:37 change format of logging statements?
Previous Message Matthew Hixson 2007-04-23 18:32:32 using Postgres with Sequoia