UNICODE

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: UNICODE
Date: 2001-10-28 08:22:24
Message-ID: 4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Emmanuel Guyot 2001-10-28 09:36:56 Date with timezone format
Previous Message Chris Ruprecht 2001-10-27 20:19:59 Re: How can I..

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2001-10-28 09:50:42 Re: UNICODE
Previous Message Carlos Augusto 2001-10-28 03:21:25 IDE

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2001-10-28 09:50:42 Re: UNICODE
Previous Message Bruce Momjian 2001-10-28 06:24:03 Re: pgindent run