(also see http://trac.edgewall.org/ticket/9885)
this is reproducable on: CentOS 5.5 (x86_64) sqlite 3.3.6-5 create a file 'testdump.txt' with: PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE test( t text ); INSERT INTO "test" VALUES(' ------------- / / -------------'); COMMIT; Load it into a new db with: cat testdump.txt | sqlite3 ttt And dump it with: sqlite3 ttt .dump > testdump2.txt Now compare the 2 files: diff -u testdump.txt testdump2.txt And see: -PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE test( t text ); INSERT INTO "test" VALUES(' ------------- - / - / +; +; -------------'); COMMIT; The diff on the PRAGMA line is not really relevant, but the other 2 lines are! grtz -- Ferry Huberts _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users