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)
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 |