11 Replies Latest reply on Jun 28, 2013 7:08 AM by Igor Kuznetsov

    How to set Sqlite to be case insensitive when unicode string comparing?

      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!