> 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