On windows platform, the following commands using windows command line prompt and sqlite3.exe worked with old versions of sqlite3.exe Can confirm that sqlite3.exe version 3.8.6 works ok restoring database from a .dump dump.sql file using these commands
echo .dump | sqlite3_v3.8.6 test.original.db > dump_v3.8.6.sql sqlite3_v3.8.6 -init dump_v3.8.6.sql test.restored.v3.8.6.db Doing the same with the current version of sqlite3.exe (version 3.13.0) corrupts the database records when there are extended characters echo .dump | sqlite3_v3.13.0 test.original.db > dump_v3.13.0.sql sqlite3_v3.13.0 -init dump_v3.13.0.sql test.restored.v3.13.0.db Could not find any related bug on the Bugs List Release Notes show changes in this area in version 3.10.0 which may have made the change Translate between MBCS and UTF8 when running in cmd.exe on Windows I have no access to the old versions downloads to establish at what version of sqlite3.exe the problem came The closest thread in this list archive is this one .DUMP output compatibility http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2016-May/066540.html Please confirm if this is a bug or a change – but if it is a change we need advice on how for the common user to achieve the simple method of dump and recreate running sqldiff to compare the two restored database versions and to compare with the original db file, shows discrepancies like these This is doing a two-way set of compares Diffs1 UPDATE "test-directories" SET path='Hidden (Cach├®) (2005)' WHERE id=56; UPDATE "test-directories" SET path='Jap├│n (2002)' WHERE id=68; UPDATE "test-directories" SET path='Caf├® de Flore (2011)' WHERE id=94; UPDATE "test-directories" SET path='WALL┬ÀE (2008)' WHERE id=118; UPDATE "test-directories" SET path='Maurice B├®jart - L''Amour, La Danse (Best Of)' WHERE id=158; UPDATE "test-directories" SET path='Struktura kryszta┼éu (1969)' WHERE id=216; UPDATE "test-directories" SET path='Pora umiera─ç (2007)' WHERE id=218; UPDATE "test-directories" SET path='Popio┼éy - The Ashes (1965)' WHERE id=219; UPDATE "test-directories" SET path='Podw├│jne ┼╝ycie Weroniki (1991)' WHERE id=220; UPDATE "test-directories" SET path='Cz┼éowiek z marmuru (1977)' WHERE id=222; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\Caf├® de Flore (2011)\Caf├® de Flore (2011).mp4' WHERE id=290; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\WALL┬ÀE (2008)\WALL┬ÀE (2008).mp4' WHERE id=392; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\Maurice B├®jart - L''Amour, La Danse (Best Of)\Maurice B├®jart - L''Amour, La Danse (Best Of).mp4' WHERE id=508; Diff2 UPDATE "test-directories" SET path='Hidden (Caché) (2005)' WHERE id=56; UPDATE "test-directories" SET path='Japón (2002)' WHERE id=68; UPDATE "test-directories" SET path='Café de Flore (2011)' WHERE id=94; UPDATE "test-directories" SET path='WALL·E (2008)' WHERE id=118; UPDATE "test-directories" SET path='Maurice Béjart - L''Amour, La Danse (Best Of)' WHERE id=158; UPDATE "test-directories" SET path='Struktura kryształu (1969)' WHERE id=216; UPDATE "test-directories" SET path='Pora umierać (2007)' WHERE id=218; UPDATE "test-directories" SET path='Popioły - The Ashes (1965)' WHERE id=219; UPDATE "test-directories" SET path='Podwójne życie Weroniki (1991)' WHERE id=220; UPDATE "test-directories" SET path='Człowiek z marmuru (1977)' WHERE id=222; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\Café de Flore (2011)\Café de Flore (2011).mp4' WHERE id=290; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\WALL·E (2008)\WALL·E (2008).mp4' WHERE id=392; UPDATE "test-media_parts" SET file='\\nas-london-1\Qmultimedia\Movies\Maurice Béjart - L''Amour, La Danse (Best Of)\Maurice Béjart - L''Amour, La Danse (Best Of).mp4' WHERE id=508; Thank You Simon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
