SQLite search without accents

Question

Is there a way to make a LIKE query without an accent in SQLite? For example, this query:

SELECT * FROM users WHERE name LIKE "Andre%"

will return:

  André the giant
 Andre Agassi
 etc.

I use Qt with QSqlDatabase if that matters.

+6

this.lau_ Dec 23 '12 at 6:59

1 answer

icktoofay · Accepted Answer · 2012-12-23T07:19:51+0000

Configure collation using sqlite3_create_collation , and then use it like this:

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