Thanks for all the replies. I'm still confused on this. It sounds like maybe UTF8 is the answer on OSX but UTF-16LE on Windows.
Whatever the answer to that, it seems there isn't a way to control the encoding within sqlite3 so I guess I won't worry about it. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>