On Jul 24, 2009, at 8:44 AM, D. Richard Hipp wrote: > SQLite database files are cross-platform. All you have to do is copy > the file to the new machine. There is no separate "external format". > The same database file format work on all platforms.
Just make sure that if you are moving to a new platform, that the data formats match those expected by SQLite. This is especially important for platforms with weird floating point formats. For example, on ARM platforms there are a couple floating point formats, and the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile switch helps accommodate them. SQLite provides support to get this right: ** Developers using SQLite on an ARM7 should compile and run their ** application using -DSQLITE_DEBUG=1 at least once. With DEBUG ** enabled, some asserts below will ensure that the byte order of ** floating point values is correct. e _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
