Re: Accent-insensitive

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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Pedro Igor
Sent: Friday, December 06, 2002 14:31
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Accent-insensitive

Does have PostgreSQL some option to allow me execute selects
accent-insensitive ?
I can´t find any reference, including the manual ....

Pedro Igor