Re: Accent-insensitive
| От | Cédric Dufour (public) |
|---|---|
| Тема | Re: Accent-insensitive |
| Дата | |
| Msg-id | 007401c29d66$b1374690$3c8addd5@cednetwork.net обсуждение исходный текст |
| Ответ на | Accent-insensitive ("Pedro Igor" <pedroigor@aip.com.br>) |
| Ответы |
Re: Accent-insensitive
|
| Список | pgsql-sql |
Use the 'to_ascii' function to convert your string to the "no accent" ASCII equivalent before accomplishing your comparison
SELECT foo FROM table WHERE ( to_ascii(foo) ILIKE to_ascii('caractères accentués') );
This does not work with all database locale (LATIN1 is OK, but LATIN9 is not).
I was actually wondering if this is efficient enough or if there is any more efficient method to accomplish this...
Cédric D.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Pedro Igor
Sent: Friday, December 06, 2002 14:31
To: pgsql-sql@postgresql.org
Subject: [SQL] Accent-insensitiveDoes have PostgreSQL some option to allow me execute selects accent-insensitive ?I can´t find any reference, including the manual ....Pedro Igor
В списке pgsql-sql по дате отправления: