> My first solution was to use a custom function, eg. transliterate_to_ascii:
>
> SELECT * FROM names WHERE transliterate_to_ascii(name) LIKE transliterate_to_ascii('%médéric%') ORDER BY transliterate_to_ascii(name);
>
> But obviously this doesn't scale very well as that function would be called a lot, as I can't use indexes.
Well, actually you can. You can create an index on the function:
```
create index i0 on names(transliterate_to_ascii(name));
```
SQLite3 libraries compiled with SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1 will be able to open and read the database. However, they will not be allowed to update it because that requires that the unknown SQL function be actually present.