Hello Peter, I use UTF-8 exclusively in the engine parts my windows applications. I just translate to UTF-16 for the GUI layer. In that way, no matter what platform I support, the DB's remain the same.
C Tuesday, May 5, 2015, 3:29:54 PM, you wrote: PH> Thanks for all the replies. I'm still confused on this. It sounds like PH> maybe UTF8 is the answer on OSX but UTF-16LE on Windows. PH> Whatever the answer to that, it seems there isn't a way to control the PH> encoding within sqlite3 so I guess I won't worry about it. PH> Pete PH> lcSQL Software <http://www.lcsql.com> PH> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and PH> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> PH> _______________________________________________ PH> sqlite-users mailing list PH> sqlite-users at mailinglists.sqlite.org PH> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Teg mailto:Teg at djii.com