Official SQLite docs state:
SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range.
I want to select records from local database by unicode string matching. But if I use 'LIKE' in the where clause, I found that sqlite is not work UPPER/LOWER with unicode. Can anyone tell me how to use string comparing case-insensitive?
Thank you very much!