actionscript 3 - SQLite and Adobe AIR - no utf-8 characters -
i have problem data want fetch sqlite database in adobe air application. use javascript.
in sqlite3 cli when use query: select * notes; result:
cześć|8 boa noite|12 até logo|13
but when want data in air using:
dbquery = new air.sqlstatement(); dbquery.sqlconnection = db; dbquery.text = "select hello, id sometable";
i have that:
cze|8 boa noite|12 @ logo|13
all specific characters removed.
where problem , how can resolve it?
i discovered problem.
i added new entities using sqlite3 cli , values inserted in wrong encoding, because when inserted values "łąśćźóż" using air adobe application or importing data database:
sqlite3 test.db < test.sql
values saved in correct encoding , when them application, displayed in correct encoding.
Comments
Post a Comment