Re: unicode

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: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>