On 13 Jul 2016, at 6:26pm, Clemens Ladisch <[email protected]> wrote:
> To fix this, use the same mechanism for both output and input: > > sqlite3 old.db .dump > dump.sql > sqlite3 new.db < dump.sql > > or > > (echo .output dump.sql && echo .dump) | sqlite3 old.db > sqlite3 -init dump.sql new.db Showing my ignorance of Windows once again ... which of the above result in dump.sql having contents encoded in UTF-8 ? I presume one does and one doesn't. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
