> > > See if you get same problem using data above. > If not, then your data is relevant to the issue. > If yes, then your sqlite is not the same as mine. > > Rgds, > Simon
The example you used, works 100% for me. I attach a sql script for which I experience the problem. Extract it and do: C:\Utils>sqlite3 -init t.sql t.db .quit -- Loading resources from t.sql C:\Utils>sqlite3 t.db .dump > t1.sql C:\Utils>del t.db C:\Utils>sqlite3 -init t1.sql t.db .quit -- Loading resources from t1.sql C:\Utils>sqlite3 t.db .dump > t2.sql C:\Utils>xd t1.sql > t1.dmp C:\Utils>xd t2.sql > t2.dmp C:\Utils>diff t1.dmp t2.dmp 5,107c5,107 < 40: 0A 5B 52 65 6C 61 74 69 76 65 50 61 74 68 5D 20 < 50: 56 41 52 43 48 41 52 28 31 30 30 29 20 20 4E 55 < 60: 4C 4C 2C 0D 0D 0A 5B 46 69 6C 65 4E 61 6D 65 5D <snip /> > 670: 61 6C 6C 79 55 70 64 61 74 65 64 46 69 6C 65 73 > 680: 22 20 56 41 4C 55 45 53 28 27 2E 27 2C 27 68 79 > 690: 62 72 69 73 2E 65 78 65 27 2C 31 29 3B 0D 0A 43 > 6A0: 4F 4D 4D 49 54 3B 0D 0A C:\Utils> regards, Francois
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users