Similar questions have been asked, but many are old and it's not clear to me exactly what the resolution is. I have a list filter with a local db query that is matching columns against user input (uses MATCH, but that is probably not significant). Both the contents of the columns and the user input can be mixed case, but the match should be case-insensitive. This has been working (for years!) for most situations, but it was recently pointed out to me by a user (in France) that if he inputs a lowercase accented character, e.g. é, it will not match a database entry containing the uppercase equivalent, e.g. É.

My understanding is that Android SQLite does not support this automatically as it does for ASCII characters, but is there a solution within Android? I have no control over what is in the database (it comes from an outside source) or what the user inputs.

Doug Gordon
GHCS Software

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
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 unsubscribe from this group and stop receiving emails from it, send an email 
to android-developers+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to