Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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

1 Answer

up vote 0 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

 
discard

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.