UNICODE

Поиск
Список
Период
Сортировка
Искать
От
Jean-Michel POURE
Тема
UNICODE
Дата
Msg-id
4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr
Список
Дерево обсуждения
Re: Ultimate DB Server "Mike Rogers" <temp6453@hotmail.com>
Re: Ultimate DB Server "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Ultimate DB Server "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Ultimate DB Server bpalmer <bpalmer@crimelabs.net>
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 по дате отправления
От: Bruce Momjian
Дата:
Сообщение: Re: pgindent run
От: Marko Kreen
Дата:
Сообщение: Re: UNICODE
FAQ