Re: [SQL] Accent-insensitive

[Cédric Dufour (public)]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Pedro Igor Sent: Friday, December 06, 2002 14:31 To: [EMAIL PROTECTED] 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