Re: [android-developers] read character unicode form sqlite

2011-04-04 Thread lbendlin
I guess we're both right in some way :-) Here's the official documentation: http://www.sqlite.org/version3.html -- 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 un

Re: [android-developers] read character unicode form sqlite

2011-04-04 Thread Kostya Vasilyev
2011/4/4 lbendlin > It doesn't actually matter how you store it as under the hood SQLite stores > everything as string. You can dso dirty type conversion tricks when reading. > > It does not store everything as a string. There are native types for integer, real and BLOB, in addition to text. Wh

Re: [android-developers] read character unicode form sqlite

2011-04-04 Thread lbendlin
It doesn't actually matter how you store it as under the hood SQLite stores everything as string. You can dso dirty type conversion tricks when reading. >From my experience SQLite uses ANSI strings though so in order to read your Unicode data back you actually have to use byte arrays for readin

Re: [android-developers] read character unicode form sqlite

2011-04-04 Thread Kostya Vasilyev
Sqlite on Android is definitely Unicode aware and safe. Make sure you store and retrieve your data as Java String objects (not byte arrays). 04.04.2011 14:00 пользователь "thavorac chun" написал: > Hi everyone, > I'm working with sqlite right now and at this this moment i found a > problem related

[android-developers] read character unicode form sqlite

2011-04-04 Thread thavorac chun
Hi everyone, I'm working with sqlite right now and at this this moment i found a problem related to reading data from sqlite that i can not solve it. For example i have a french word " Hôtel " that have been insearted to database and after reading it to represent in device, it turn to " Hà´tel "