Обсуждение: psql & UTF8

Working on UTF support in tsearch2 I noticed different output of psql:

1) initdb with SQL_ASCII:
contrib_regression=# select 'jisa n asd n asld kl   ans    d
contrib_regression'# asdfjkl; asdf kl;amsdf';                         ?column?
----------------------------------------------------------- jisa n asd n asld kl   ans    d
asdfjkl; asdf kl;amsdf
(1 row)

2) initdb with UTF8
contrib_regression=# select 'jisa n asd n asld kl   ans    d
contrib_regression'# asdfjkl; asdf kl;amsdf';              ?column?
------------------------------------ jisa n asd n asld kl   ans    d
asdfjkl; asdf kl;amsdf
(1 row)


Length of '--------' string is different. This difference is a reason for 
installcheck failture of tsearch2 on UTF8 inited db.

Is it supposed behaviour of psql?


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 

On Fri, Dec 09, 2005 at 01:39:50PM +0300, Teodor Sigaev wrote:
> Working on UTF support in tsearch2 I noticed different output of psql:

<snip>
>
> Length of '--------' string is different. This difference is a reason for
> installcheck failture of tsearch2 on UTF8 inited db.
>
> Is it supposed behaviour of psql?

Well, the fact that there's a difference is odd, though I imagine it
has something to do with the client_encoding setting.

There is a patch in the queue to handle multiline strings better which
should remove the difference...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

The regression tests  are known to fail on non-SQL_ASCII encodings for 
this and similar reasons.

cheers

andrew

Teodor Sigaev wrote:

> Working on UTF support in tsearch2 I noticed different output of psql:
>
> 1) initdb with SQL_ASCII:
> contrib_regression=# select 'jisa n asd n asld kl   ans    d
> contrib_regression'# asdfjkl; asdf kl;amsdf';
>                          ?column?
> -----------------------------------------------------------
>  jisa n asd n asld kl   ans    d
> asdfjkl; asdf kl;amsdf
> (1 row)
>
> 2) initdb with UTF8
> contrib_regression=# select 'jisa n asd n asld kl   ans    d
> contrib_regression'# asdfjkl; asdf kl;amsdf';
>               ?column?
> ------------------------------------
>  jisa n asd n asld kl   ans    d
> asdfjkl; asdf kl;amsdf
> (1 row)
>
>
> Length of '--------' string is different. This difference is a reason 
> for installcheck failture of tsearch2 on UTF8 inited db.
>
> Is it supposed behaviour of psql?
>
>