Received: from mailhub7.isdnet.net (mailhub7.isdnet.net [195.154.209.27]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9S8MgP05037 for ; Sun, 28 Oct 2001 03:22:44 -0500 (EST) (envelope-from jm.poure@freesurf.fr) Received: from station ([195.154.28.3]) by mailhub7.isdnet.net (8.9.3/8.9.3) with ESMTP id JAA24289 for ; Sun, 28 Oct 2001 09:22:38 +0100 (CET) Message-Id: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> X-Sender: jm.poure@pop.freesurf.fr X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Sun, 28 Oct 2001 09:22:24 +0100 To: pgsql-hackers@postgresql.org From: Jean-Michel POURE Subject: UNICODE Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9S8VXM10541 X-Archive-Number: 200110/977 X-Sequence-Number: 14700 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