The actual checking is done in INSERT/UPDATE/COPY. However, the
checking is currently very limited: every byte of a mutibyte character
must be greater than 0x7f.
> Tatsuo,
>
> do I understand correctly that there is no checking for
> convertion between local charset and unicode in insert and
> checking is done only in select ?
>
> test=# create table qq (a text);
> CREATE TABLE
> test=# \encoding koi8
> test=# insert into qq values('бартунов');
> INSERT 24617 1
> test=# \encoding unicode
> test=# select * from qq;
> a
> ----------
> п�п�я�������п�п�
> (1 row)
>
> test=# \encoding unicode
> test=# insert into qq values('бартунов');
> INSERT 24618 1
> test=# select * from qq;
> a
> ----------
> п�п�я�������п�п�
>
> (2 rows)
>
> test=# \encoding koi8
> test=# select * from qq;
> WARNING: UtfToLocal: could not convert UTF-8 (0xc2c1). Ignored
> WARNING: UtfToLocal: could not convert UTF-8 (0xd2d4). Ignored
> WARNING: UtfToLocal: could not convert UTF-8 (0xd5ce). Ignored
> WARNING: UtfToLocal: could not convert UTF-8 (0xcfd7). Ignored
> a
> ----------
> бартунов
>
> (2 rows)
>
>
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
