I was trying some .dump round-trips like sqlite3 old.db .dump | sqlite3 new.db
and noticed if old.db is utf16, ie. pragma encoding=utf16, then new.db doesn't get that but instead is utf8. Is that intentional? Would slipping a pragma into the .dump output preserve the db coding? (I don't want the .dump text output to be utf16, and this was only an experiment to see what came out. Perhaps it doesn't matter to anything.) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users