Problem with multibyte encoding and locale support

From: "Natalya Pyalling" <mak(at)rtsoft(dot)msk(dot)ru>
To: <pgsql-admin(at)postgreSQL(dot)org>, <pgsql-general(at)postgreSQL(dot)org>
Subject: Problem with multibyte encoding and locale support
Date: 2000-08-16 08:27:13
Message-ID: 005901c0075b$ca0b4b10$31c8a8c0@makushina.rtsoft.msk.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, all!

I want to configure postgresql as server with encoding on the fly (Postgres
7.0.2). I have few databases with KOI8 encoding and few ones with WIN
encoding. I ran ./configure --enable-locale --enable-multibyte=KOI8, made
and installed it. Then I ran initdb -E KOI8 and loaded my databases with
proper encoding in createdb.
Case 1. When I tried to connect db
$psql news
=# \encoding KOI8
=# select * from subscriber order by last;
I had got correct result. (DB news have KOI8 encoding).

Case 2. I tried to connect another db isrts with WIN encoding.
=# \c isrts
=# \encoding KOI8
=# select * from istor order by manager;
I had got WRONG result. (DB isrts have WIN encoding) The sort order was
wrong.

I recompiled postgresql server ./configure --enable-multibyte=KOI8 and tried
same commands.
In first case (db news with KOI8 encoding) I had WRONG result. The sort
order was wrong again.
In the second case (db isrts with WIN encoding) I had CORRECT result.

What does it mean? What did I do wrong?
Any help would be appricated.
Thanks.

Good Luck, Natalya Pyalling.

P.S. Please, reply to mak(at)rtsoft(dot)msk(dot)ru(dot)

Browse pgsql-admin by date

  From Date Subject
Next Message Meibell Contreras 2000-08-16 14:51:53 Multiples databases
Previous Message Rob Stoddard 2000-08-16 07:10:16 Suffering