vendredi 22 avril 2016

Strings pulled from sqlite3 do not display accented characters correctly on Android

I created a .sql file using DB browser for SQLite and then I used sqlite3 command line tool to create a .db file which I used as an asset in my Android app code. On the device however all UTF-8 characters such as à,é etc. display incorrectly. One such example is the word "ÎLE" which displays on the phone screen as "ÃŽLE". I checked the encoding of the .sql file and SQLiteExpert says that the format is set to UTF-8. Is there any other reason I might be not thinking of as to why the phone doesn't display the strings correctly after pulling them from the database?

Aucun commentaire:

Enregistrer un commentaire