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.
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,
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\)