Hello Everybody, I am having a cross-platform Intel/ARM sqlite file issue.
"...the file format is cross-platform. A database that is created on one machine can be copied and used on a different machine with a different architecture." So, how come I get this (sqlite 3.5.9 and ext3 on both IntelHost and ARMHost): IntelHost% sqlite3 test.sqlite 'create table tab (one real, two real);\ insert into tab values (1.2, 1.3);' IntelHost% sqlite3 test.sqlite 'select * from tab;' 1.2|1.3 IntelHost% scp test.sqlite ARMHost: ARMHost% sqlite3 test.sqlite 'select * from tab;' 4.66726164313171e-62|-9.25596534088728e+61 ARMHost% sqlite3 test.sqlite 'insert into tab values (2.1, 2.2);' ARMHost% sqlite3 test.sqlite 'select * from tab;' 4.66726164313171e-62|-9.25596534088728e+61 2.1|2.2 IntelHost% scp ARMHost:test.sqlite . IntelHost% sqlite3 test.sqlite 'select * from tab;' 1.2|1.3 -9.25596534178523e+61|-2.35343828009147e-185 Did I miss something ? Thank you very much, Laurent _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
