insensitive search

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.

---

使用sqlite3_create_collation设置排序规则，然后像这样使用它：

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

链接地址: http://www.djcxy.com/p/67752.html

上一篇: C

下一篇: 不敏感的搜索