Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 1

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.