[android-developers] SQLite case insensitive matching
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.
Re: [android-developers] Signing App
tx justin may be my english not that good i asked export signed application package vs export android application both are way to signed the app but which one is better tx RK On Fri, Apr 17, 2015 at 6:51 PM, Justin Anderson magouyaw...@gmail.com wrote: http://lmgtfy.com/?q=android+signed+vs+unsigned+application On Fri, Apr 17, 2015 at 8:08 AM Rahul Kaushik rahulkaushi...@gmail.com wrote: Hello Team What is the difference between android export signed application package or export android application which is a better way to sign an app Please Suggest TX RK -- 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. -- 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. -- 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.
[android-developers] Re: SQLite case insensitive matching
There rings a bell with your problem description. It's a while ago, but I remember now that I'm having similar problems with one of my apps and non-ASCII characters. Since you are using the MATCH operator I assume you are also using the FTS3 extension. I just found this piece of information on the documentation page for FTS: *All uppercase characters within the ASCII range (Unicode codepoints less than 128), are transformed to their lowercase equivalents as part of the tokenization process. Thus, full-text queries are case-insensitive when using the simple tokenizer. * (source: http://sqlite.org/fts3.html#tokenizer) That may explain why French accented lower-case letters are not correctly matched against their upper case equivalents, since they are effectively ignored by the default tokenizer. The same page mentions further down that the unicode61 tokenizer implementation solves that problem correctly, however it looks like it is only available for FTS4, which in turn is only available since Android ICS (see http://stackoverflow.com/questions/6339022/sqlite3-fts4-match-and-android). A dirty workaround would be to create an ORed match query for both upper case and lower case versions of accented letters: SELECT * FROM MyTable WHERE content MATCH 'Écuter OR écuter' This however can get out of hand the more accented letters are contained in your search query. But if the data in your database is written according to standard writing rules (all lower case letters except for titles and words at the beginning of a sentence) you could focus just on the first letter of the search term for creating those ORed match queries. On Saturday, April 18, 2015 at 4:03:28 AM UTC-7, Doug Gordon wrote: 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.
[android-developers] Receive Callback from Service
Is there any mechanism to receive a callback from service through AIDL without any client intervention.Already i have implemented a two way communication through AIDL, but still i couldnt figure out how to sent a callback without a client call.Any insights into this will be very helpfull. -- 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.
