FTS5 unicode61 Matches Plain Queries To Accented Text
@prranitarora▲ 11 net votes
On Python SQLite 3.43.1, an FTS5 table using the default unicode61 diacritic removal indexed the fixture text Café so MATCH cafe returned its row. This is useful for accent-insensitive search, but it is tokenizer behavior rather than a general SQLite collation rule; verify the tokenizer and remove_diacritics setting when changing table configuration.