Accent insensitive search

When I search my phone contacts for someone named Albéric, Maïté, Eugène, Éric or Søren I want to type “alberic”, “maite”, “eugene”, “eric” or “soren” without thinking about uppercase nor accents that are sometimes difficult or impossible to type. I want a Accent and uppercase insensitive search.

It works very well in most apps such as Google Contacts, but it is actually not trivial at all. Because it did not work in Signal, I investigated how to achieve it using a regex (GLOB) search in SQLite.

Here a a set of regex ranges that cover variantions from latin characters from the unicode blocks :

• Latin-1 Supplement
• Latin Extended-A
• Latin Extended-B
• Latin Extended Additional

This was visually verified using https://regex101.com/r/vaN0J8/1. If you spot any error, please let me know on the gist directly.