SQLite Forum

How to avoid 'row X missing from index' when using a custom collation?
Login
Add to your existing technique the. idea that each name should be stored twice: once with accents as input, and once in normalised form, in this case, transformed to ASCII and uppercased.  Then you can do searching and sorting on the normalised column.