postgresql unicode lower/upper problem - Mailing list pgsql-general

From Sergey Levchenko
Subject postgresql unicode lower/upper problem
Date
Msg-id e3ffbf240503230804581ced7b@mail.gmail.com
Whole thread Raw
Responses Re: postgresql unicode lower/upper problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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?

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL support
Next
From: "A. Mous"
Date:
Subject: Re: Simple query takes a long time on win2K