Character encoding
SQLite databases store strings internally in UTF-8, while Java stores them as UTF-16. The Database API handles the conversion of strings internally, so you don't need to do any encoding or conversion.
The SQLite encoding pragma is not supported in the Database API, so you can't set another encoding. You must use UTF-8 supported characters in your SQLite database.
Next topic: Create an SQLite database
Previous topic:
SQLite database
files