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