I work with language with special characters (example: e -> é). I have a query with a
LIKE but when I search a word with special char and my query doesn't have the special char, I don't get the results I expect:
select * from a where name like '%e%'
The above returns no results when the database contains "dés". Is there a way to have this query return the desired results.