Horton
Menu

Re: Sequence of characters not supported by psql/pg_dump

Tatsuo Ishii <t-ishii@sra.co.jp>

View thread
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: sminne@allis.fr
Cc: pgsql-bugs@postgresql.org, pbittner@allis.fr
Date: 2001-01-11T07:24:32Z
Lists: pgsql-bugs 
> 	I use PostgreSQL 7.0.2 on linux.
> 	The base was set with initdb -E UNICODE.
> 
> 	I have many Strings with accents (french language).
> 	Some of them aren't supported by queries or pg_dump:
> 
> WORKING EXAMPLE:
> DB=# select * from element_attribute  where java_lang_string like 'Scholtè_s';

Are you sure that the letter (LATIN SMALL LETTER E WITH GRAVE) is
encoded in UTF-8? It's 2 bytes long and starting with 0xc...
--
Tatsuo Ishii