I have some annoying problem with my AIR application
The application is communicating with a local DB (sqllite).
as part of initial installation I'm checking if the db exist.
in case not then:
For some reason, on the tables creation step the sqllite db become encoded as UTF-16le instead of UTF-8.
The question is how can I make the tables creation step to leave the db as UTF-8
thanks in advance for your help.
This is my creation code
The "file" contain the following information
CREATE TABLE IF NOT EXISTS MYTABLE
MYTABLE_VERSION NUMBER NOT NULL,
MYTA|BLE_INSERT_DATE DATE NOT NULL
var stream:FileStream = new FileStream();
var xml:XML = XML(stream.readUTFBytes(stream.bytesAvailable));
var statement:XML = null;
for each (statement in xml.statement)
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = connection;
stmt.text = statement;