Postgres Pro
Downloads
Home   >   mailing lists

psql & UTF8 - Mailing list pgsql-hackers

From Teodor Sigaev
Subject psql & UTF8
Date
Msg-id 43995EF6.60401@sigaev.ru
Whole thread Raw
Responses Re: psql & UTF8  (Martijn van Oosterhout <kleptog@svana.org>)
Re: psql & UTF8  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: psql patch: new host/port
Next
From: Simon Riggs
Date:
Subject: Re: Warm-cache prefetching