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.

Close

case sensitivity and accentuated chars

Help
2005-09-26
2013-04-23
  • When using MySQL if I use the following SQL:
    select * from table where column like '%em%';
    It will return things like:
    "manuel"
    "raemand"
    "istmia"
    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,
    Cassiano

     
    • 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 : http://www.sqlite.org/lang_expr.html\)
      Fred