Thread: 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.]