Conversion on the fly from KOI8-R to WIN1251 is invalid

From: "Roman A(dot)Grigorovich" <atz(at)atz(dot)msk(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Conversion on the fly from KOI8-R to WIN1251 is invalid
Date: 2003-04-03 19:52:55
Message-ID: 921322029843.20030403235255@atz.msk.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

CREATE DATABASE TEST WITH ENCODING = 'KOI8';
CREATE TABLE TEST (LOGIN VARCHAR);

SET CLIENT_ENCODING 'KOI8';

INSERT INTO TEST (LOGIN) VALUES ('\206pesto\206');

SELECT LOGIN FROM TEST;
It's return string '†pesto†';

Then i try
SET CLIENT_ENCODING = 'WIN';

SELECT LOGIN FROM TEST;
It's return string 'pesto '

The code of last char in this string (in decimals) is 32 (space).
Why? Where the chars with code 206 (in octal) ?
Is this bug?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-04-03 20:52:10 Bug #932: some system tables are not accessible
Previous Message Dennis Gearon 2003-04-03 19:16:55 Re: [GENERAL] Suggestion