On Sun, Oct 28, 2001 at 09:22:24AM +0100, Jean-Michel POURE wrote: > Dear all, > > I am running PostgreSQL 7.1.2 with UNICODE support in production. > Maybe I miss something about UNICODE:
> SELECT * FROM test WHERE source_content ILIKE '%accepté%' ---> returns > nothing > SELECT * FROM test WHERE source_content ILIKE '%accepte%' ---> returns > nothing > > The same happens from ODBC, PHP and psql. Can you reproduce this? 1) Did you compile PostgreSQL with --enable-locale 2) Did you set correct locale for postmaster (LANG=xxx) -- marko ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
