Thanks Daniel, I´ve seen the bug: "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. For example, the expression *'a' LIKE 'A'* is TRUE but *'æ' LIKE 'Æ'* is FALSE."
There is another option with COLLATE expresions. NOCASE but only 26 characters(ASCII) Regards On 14 October 2010 18:34, Daniel Drozdzewski <[email protected]>wrote: > inaki, > > Please have a look at SQLite collation options. Below statements will > return different results: > > SELECT * from table WHERE column LIKE '%your_text%' COLLATE LOCALIZED > SELECT * from table WHERE column LIKE '%your_text%' COLLATE BINARY > SELECT * from table WHERE column LIKE '%your_text%' COLLATE UNICODE > > Please also find below, that there is a bug in SQLite and case > sensitivity of characters outside of ASCII range (which I see you have > discovered): > > http://www.sqlite.org/lang_expr.html#like > > good luck, > -- > Daniel Drozdzewski > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
