[android-developers] sqlite can't show chinese words

2009-09-10 Thread tstanly

hi all,

I found that sqlite can't store chinese words and will shows random
code in
the application when retrieve data.

can somebody give some help?

thanks!
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---



[android-developers] sqlite can't show chinese words issue

2009-09-10 Thread tstanly

hi guys,

I'm sorry about ask this question again,
I know that sqlite store format is UTF-8,
so I will describe the whole process that I used sqlite.

first I create a table named map by shell mode in the emulator,

# sqlite  create table map ( id INTEGER PRIMARY KEY,chinese_word TEXT
NOT NULL,
 en_word TEXT NOT NULL);

second, insert a record by shell mode in the emulator,

# sqlit  insert into map values (1,CHINESE WORD,hello);

then, there are two spinner in my app and retrieve column
chinese_word, en_word
by sql query.

finally in my app, the first spinner shows RANDOM CODE,
and second spinner shows correct word hello.

so, can somebody tell me how can I solve for that

I really appreciate.



--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---