iOS - 如何使用 SQLite.swift 进行变音符号不敏感搜索？

Question

我正在使用 SQLite.swift。有什么办法可以在 SQLite 中进行不区分变音符号的 LIKE 查询吗？例如，这个查询:

SELECT * FROM users WHERE name LIKE "thu%"

会返回:

thử
thu
thư
etc.

Answer 1

来自 the documentation :

We can create custom collating sequences by calling createCollation on a database connection.

try db.createCollation("NODIACRITIC") { lhs, rhs in
    return lhs.compare(rhs, options: .DiacriticInsensitiveSearch)
}

We can reference a custom collation using the Custom member of the Collation enumeration.

restaurants.order(collate(.Custom("NODIACRITIC"), name))
// SELECT * FROM "restaurants" ORDER BY "name" COLLATE "NODIACRITIC"

在您的情况下，您可以在之后执行以下查询:

SELECT * FROM users WHERE name COLLATE NODIACRITIC LIKE 'thu%'