You're not getting any results because those are two different characters. I'm not familiar enough with how UTF8 handles accents, so i'm not aware of any tricks to circumvent this issue easily, but there is a simple solution: if you want to keep the search fast, keep a "non-accented" version of each word in the dictionary as well. If you want to keep the dictionary small but take a performance hit, always do a search for both the regular letter and all its possible accents.
P.S - letters with accents can be unicode as well... it's actually better this way than to use a special character set. On Friday, March 22, 2013 7:17:24 AM UTC+2, Seshu wrote: > > Hi, > Thanks for the reply. i searched in Google regarding select > statement for retrieving uni-code characters but unfortunately i > didnt got any query. can u post a sample query how to retrieve such > type of unicode characters.. > > Thanks and Regards, > S.Seshu. > > On Mar 22, 1:25 am, lbendlin <l...@bendlin.us> wrote: > > have you tried searching the web for "sqlite unicode"? > > > > > > > > > > > > > > > > On Thursday, March 21, 2013 8:45:29 AM UTC-4, Seshu wrote: > > > > > Hi All, > > > I am doing a small dictionary app and the data is in sq-lite > > > file. when i search the keyword then corresponding words ll showing in > > > a list view. in my database i have special characters i.e., > > > ábaco, > > > ábaco psicométrico > > > > > when i entered keyword a then above words also i want. Any body know > > > how to retrieve such type of special characters. > -- -- 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/groups/opt_out.
