Home / server / Questions / 266373
Accepted
Ivan
Asked: 2011-05-05 11:16:01 +0800 CST

PostgreSQL: Accent/diacritic insensitive search

  • 772

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.

postgresql

1 Answers

  1. Best Answer
    • 2