Re: Bug in UTF8-Validation Code?
Albe Laurenz <all@adv.magwien.gv.at>
From: "Albe Laurenz" <all@adv.magwien.gv.at>
To: "Mario Weilguni *EXTERN*" <mweilguni@sime.com>, <pgsql-hackers@postgresql.org>
Date: 2007-03-13T13:46:26Z
Lists: pgsql-hackers
Mario Weilguni wrote:
> Steps to reproduce:
> create database testdb with encoding='UTF8';
> \c testdb
> create table test(x text);
> insert into test values ('\244'); ==> Is akzepted, even if not UTF8.
This is working as expected, see the remark in
http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQ
L-SYNTAX-STRINGS
"It is your responsibility that the byte sequences you create
are valid characters in the server character set encoding."
Yours,
Laurenz Albe