SQLite will faithfully return whatever sequence of bytes you passed in when inserting the data.
If you insert ISO-ANSI encoded data then please do not expect the returned data to be magically converted to UTF. BTW, this mailing list does not support attachments. -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Wang, Wei Gesendet: Donnerstag, 02. Juni 2016 08:33 An: [email protected] Betreff: [sqlite] Some Latin characters cannot be handled correctly Recently I faced a problem that when I opened my database with the SQLite Developer tool, if I set the encoding to UNICODE, I failed to queried out the result which including some Latin characters. But when I set the encoding to ASNI, everything is ok. Please see the attached picture to find the details. I supposed that SQLite or SQLite Developer cannot handle some special characters correctly for UNICODE. Best Regards, Wang Wei ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: [email protected] This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
