PostgreSQL 8.3.5 client_encoding WIN1251 trouble
Hello!
Still having troubles with client_encoding
I have database in KOI8-R encoding. When I try to SET NAMES 'WIN' and
do a select, I have such error:
ERROR: character 0x8b9a of encoding "MULE_INTERNAL" has no equivalent
in "WIN1251"
The database is about 3Gb size and needs to be in koi8, but client
encoding needs to be windows-1251
What should I do? Searching mailing list gives patches to
cyrillic_and_mic.c for such kind of problems, but in PostgreSQL v8.3.5
they're alredy in (out of the box).
Please help...
On Tue, Nov 25, 2008 at 04:19:27PM +0300,
Dr.ONE <drone76@mail.ru> wrote
a message of 22 lines which said:
I have database in KOI8-R encoding. ... ERROR: character 0x8b9a of
encoding "MULE_INTERNAL" has no equivalent in "WIN1251"
Are you sure it is KOI8? The KOI8 encoding is monobyte and you can see
in PostgreSQL message a two-bytes character and MULE_INTERNAL is not
KOI8 <http://www.postgresql.org/docs/current/interactive/multibyte.html>
[My advice is to always put the database in UTF-8 but that's another
story.]