UNICODE
От | Jean-Michel POURE |
---|---|
Тема | UNICODE |
Дата | |
Msg-id | 4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr обсуждение исходный текст |
Ответы |
Re: UNICODE
Re: UNICODE Re: UNICODE |
Список | 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
В списке pgsql-hackers по дате отправления: