Conversion on the fly from KOI8-R to WIN1251 is invalid
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?
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