SQLite Forum

Searching in text columns with Unicode folding
FYI I made a very simple library for a good customer to add EU accent-enabled UPPER and LOWER functions: https://github.com/brodybits/sqlite3-eu

It is possible to use the library to either add separate EU-enabled UPPER & LOWER functions, like UPPER_EU & LOWER_EU, or overwrite the existing UPPER & LOWER functions.

For the sake of Unicode folding beginners like myself, you should be able to do the case-insensitive LIKE condition in a statement like this:

    SELECT rowid, name FROM t1 WHERE LOWER_EU(name2) LIKE LOWER_EU(?)