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.

link|improve this question

74% accept rate
What version of the database and what encoding is your string? There's been a lot of bugs and changes in the character set encoding functions throughout most of 8.x. – DerfK May 4 '11 at 19:50
feedback

1 Answer

up vote 0 down vote accepted

You might find either of these solutions useful:

link|improve this answer
Thanks! I also found I could use the TRANSLATE function. – Ivan May 6 '11 at 1:34
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.