> 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
