UNICODE

Jean-Michel POURE <jm.poure@freesurf.fr>

From: Jean-Michel POURE <jm.poure@freesurf.fr>
To: pgsql-hackers@postgresql.org
Date: 2001-10-28T08:22:24Z
Lists: pgsql-hackers, pgsql-general
Dear all,

I am running PostgreSQL 7.1.2 with UNICODE support in production.
Maybe I miss something about UNICODE:

CREATE TABLE "test" (
   "source_oid" serial,
   "source_timestamp" timestamp,
   "source_creation" date DEFAULT 'now',
   "source_modification" date DEFAULT 'now',
   "source_content" text
);

INSERT INTO test (source_content) VALUES ('Photocopie du permis de 
construire accepté.');

Now, when trying :
SELECT * FROM test WHERE source_content ILIKE '%accept%';  ---> returns the 
record;
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?

I have tried
Best regards,
Jean-Michel POURE