postgresql unicode lower/upper problem

From: Sergey Levchenko <sector119(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql unicode lower/upper problem
Date: 2005-03-23 16:04:19
Message-ID: e3ffbf240503230804581ced7b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Mous 2005-03-23 16:07:47 Re: Simple query takes a long time on win2K
Previous Message Joshua D. Drake 2005-03-23 16:01:44 Re: PostgreSQL support