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
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

