Re: Conversion on the fly from KOI8-R to WIN1251 is invalid - Mailing list pgsql-bugs

From Tatsuo Ishii
Subject Re: Conversion on the fly from KOI8-R to WIN1251 is invalid
Date
Msg-id 20030409.113105.41629331.t-ishii@sra.co.jp
Whole thread Raw
In response to Conversion on the fly from KOI8-R to WIN1251 is invalid  ("Roman A.Grigorovich" <atz@atz.msk.ru>)
List 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?

What is your PostgreSQL version?
--
Tatsuo Ishii

pgsql-bugs by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: When to sort texts data encoded in UTF-8, retrieve as
Next
From: Tom Lane
Date:
Subject: Re: ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2