PostgreSQL: Accent/diacritic insensitive search

Question

Is there a way to do a query on PostgreSQL that will ignore accents on the columns?

SELECT * FROM people WHERE name ILIKE 'ivan'

I want a query like the one above to return records whose name is 'Iván', for example.

Answer 1

You might find either of these solutions useful:

• http://wiki.postgresql.org/wiki/Strip_accents_from_strings
• http://wiki.postgresql.org/wiki/Strip_accents_from_strings,_and_output_in_lowercase