SQLite accent-insensitive search
Solution 1:
Set up a collation using sqlite3_create_collation and then use it like this:
SELECT * FROM users WHERE name LIKE "Andre%" COLLATE NOACCENTS
SQLite accent-insensitive search
Solution 1:
Set up a collation using sqlite3_create_collation and then use it like this:
SELECT * FROM users WHERE name LIKE "Andre%" COLLATE NOACCENTS