[android-developers] Re: Retreive Special characters from sqlite files.

2013-03-25 Thread Zsolt Vasvari
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

[android-developers] Re: Retreive Special characters from sqlite files.

2013-03-25 Thread Piren
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

[android-developers] Re: Retreive Special characters from sqlite files.

2013-03-24 Thread Piren
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

[android-developers] Re: Retreive Special characters from sqlite files.

2013-03-21 Thread lbendlin
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

[android-developers] Re: Retreive Special characters from sqlite files.

2013-03-21 Thread Seshu
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