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]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to