SQLite accent-insensitive search

Question

Is there any way to do an accent-insensitive LIKE query in SQLite? For example, this query:

SELECT * FROM users WHERE name LIKE "Andre%"

would return:

André the Giant
Andre Agassi
etc.

I'm using Qt with QSqlDatabase if it makes any difference.

did you found a solution ? thx – SpongeB0B Aug 18 '23 at 15:20 — SpongeB0B, Aug 18 '23 at 15:20

score 3 · Accepted Answer · answered Dec 23 '12 at 07:19

3

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

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

answered Dec 23 '12 at 07:19

icktoofay

7

> How to setup sqlite3_create_collation in SQLite? Could you provide any link? – Rakesh Chaudhari Jul 03 '18 at 07:27
2

This is really a bad answer. It's not explaining anything I have no idea why someone market it as answered. – Nicolas Belley Jan 11 '22 at 14:21

1 Answers1