Re: PostgreSQL 8.3.5 client_encoding WIN1251 trouble

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: "Dr(dot)ONE" <drone76(at)mail(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.3.5 client_encoding WIN1251 trouble
Date: 2008-11-28 16:30:20
Message-ID: 20081128163020.GA30774@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 25, 2008 at 04:19:27PM +0300,
Dr.ONE <drone76(at)mail(dot)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.]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-28 16:36:05 Re: [TextSearch] syntax error while parsing affix file
Previous Message Ioana Danes 2008-11-28 16:19:20 Re: Using postgres.log file for replication