SQLite accent-insensitive search SQLite accent-insensitive search sqlite sqlite

SQLite accent-insensitive search


Set up a collation using sqlite3_create_collation and then use it like this:

SELECT * FROM users WHERE name LIKE "Andre%" COLLATE NOACCENTS