| 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: | Whole Thread | Raw Message | 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
| 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.. |
| 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 |
| 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 |