[android-developers] Re: Retreive Special characters from sqlite files.
P.S - letters with accents can be unicode as well... it's actually better this way than to use a special character set. UTF-8 is just an encoding of Unicode. -- -- 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.
[android-developers] Re: Retreive Special characters from sqlite files.
Duh, i wasn't talking about that. He seems to imply that letters with accents = unicode, which is not true. He can build his dictionary using ASCII and still support accents. On Monday, March 25, 2013 8:23:25 AM UTC+2, Zsolt Vasvari wrote: P.S - letters with accents can be unicode as well... it's actually better this way than to use a special character set. UTF-8 is just an encoding of Unicode. -- -- 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.
[android-developers] Re: Retreive Special characters from sqlite files.
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.
[android-developers] Re: Retreive Special characters from sqlite files.
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.
[android-developers] Re: Retreive Special characters from sqlite files.
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.