Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.


case sensitivity and accentuated chars

  • When using MySQL if I use the following SQL:
    select * from table where column like '%em%';
    It will return things like:
    The same does not happen in my tests with SQLite... Is there a way to make SQLite behave the same as MySQL?
    Thanks a lot,

    • Hi,
      LIKE is not case sensitive!
      the jocker is '%' for matching several characteres and '_' for one!
      If you want case sensitive you can use 'GLOB' where the jockers was unix like.

      For accentuated chars!! it's a bug of SQLite :
      SQLite only understands upper/lower case for 7-bit Latin characters (see :\)