When utf-8 encoded data is used in queries executed at runtime e.g. during data insertion to database that result in runtime sqlite error - e.g. syntax error. Such errors disappear when values are non-unicode (non-accented).

To repeat issue compile and run provided sample.

Expected output from application run:

test mdm.FileSystem.fileExists=>
PASSED file at: F:\tickets\26618\my_db.sqlite removed
test mdm.Database.SQLite.open(F:\tickets\26618\my_db.sqlite)=>
PASSED
test mdm.Database.SQLite.runQuery(CREATE TABLE my_table(first_name TEXT, last_name TEXT);)=>
PASSED
TEST insertion of ascii based values
TEST mdm.Database.SQLite.runQuery(INSERT INTO my_table(first_name, last_name) VALUES("stefek", "burczymucha");) =>
PASSED
TEST select of ascii based values
TEST mdm.Database.SQLite.runQuery(SELECT first_name, last_name FROM my_table) =>
PASSED
TEST value of field first_name=stefek =>
PASSED
TEST value of field last_name=burczymucha =>
PASSED
test mdm.Database.SQLite.runQuery(DELETE FROM my_table)=>
PASSED
TEST insertion of UTF-8 based values
TEST mdm.Database.SQLite.runQuery(INSERT INTO my_table(first_name, last_name) VALUES("słoń", "trąbalski");) =>
PASSED
TEST select of utf-8 based values
TEST mdm.Database.SQLite.runQuery(SELECT first_name, last_name FROM my_table) =>
PASSED
TEST value of field first_name=słoń =>
PASSED
TEST value of field last_name=trąbalski =>
PASSED
mdm.Database.SQLite.close(F:\tickets\26618\my_db.sqlite)

current output:

test mdm.FileSystem.fileExists=>
PASSED file at: F:\tickets\26618\my_db.sqlite removed
test mdm.Database.SQLite.open(F:\tickets\26618\my_db.sqlite)=>
PASSED
test mdm.Database.SQLite.runQuery(CREATE TABLE my_table(first_name TEXT, last_name TEXT);)=>
PASSED
TEST insertion of ascii based values
TEST mdm.Database.SQLite.runQuery(INSERT INTO my_table(first_name, last_name) VALUES("stefek", "burczymucha");) =>
PASSED
TEST select of ascii based values
TEST mdm.Database.SQLite.runQuery(SELECT first_name, last_name FROM my_table) =>
PASSED
TEST value of field first_name=stefek =>
PASSED
TEST value of field last_name=burczymucha =>
PASSED
test mdm.Database.SQLite.runQuery(DELETE FROM my_table)=>
PASSED
TEST insertion of UTF-8 based values
TEST mdm.Database.SQLite.runQuery(INSERT INTO my_table(first_name, last_name) VALUES("słoń", "trąbalski");) =>
FAIL unrecognized token: ""s"

That is: application test fails when unicode data is used in query (to insert data into table).

Workaround:
- use external tool to include data into table
- or encode/decode data using escape/unescape flash plugin features before insertion to database and after reading from database