Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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
up vote 2 down vote accepted

You might find either of these solutions useful:

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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