Re: psql & UTF8

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql & UTF8
Date: 2005-12-09 16:42:25
Message-ID: 4399B3F1.5050400@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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?
>
>

In response to

  • psql & UTF8 at 2005-12-09 10:39:50 from Teodor Sigaev

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-12-09 16:44:10 Re: Upcoming PG re-releases
Previous Message Tom Lane 2005-12-09 16:39:15 Re: Log of CREATE USER statement