>
>
> 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

Reply via email to