I modify pg_createcluster and add locale options
exec $initdb, '--locale', 'ru_RU.UTF-8', '--encoding', 'UTF-8', '-D', $datadir
then drop and create cluster with my locale. now lower and upper work
good with unicode.
P.S.
it's bad that we can not modify lc_ctype and lc_collate from
postgresql.conf
Sergey Levchenko <[EMAIL PROTECTED]> writes:
> 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
I think the problem is you selected a database encoding that doe
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)