SQLite and Unicode
Posted: Mon Mar 14, 2016 2:16 am
First, my apologies if this question is trivial or if it's been answered 100 times already.
I have a sqlite database with text in unicode utf16. When I use it with programs like SQLiteStudio there's no problem with the database. However, from LiveCode I can't query the database for text in Unicode (it returns empty). And when I query the DB using numeral fields, the Unicode text (is Greek, if you are wondering) are rubbish.
Again, I am afraid this can be a quite trivial question.
I am using LC 7.1.2 on a Mac (OS X 10.11).
Best,
Daniel
I have a sqlite database with text in unicode utf16. When I use it with programs like SQLiteStudio there's no problem with the database. However, from LiveCode I can't query the database for text in Unicode (it returns empty). And when I query the DB using numeral fields, the Unicode text (is Greek, if you are wondering) are rubbish.
Again, I am afraid this can be a quite trivial question.
I am using LC 7.1.2 on a Mac (OS X 10.11).
Best,
Daniel