-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Simon Slavin wrote: > SQLite3 is any version of SQLite from 3.0.0 upwards. In the move from 2.x.x > to 3.x.x there were so many changes in how SQLite worked internally that it > was almost a different product.
The changes aren't actually that big. The major difference is that SQLite version 2 stored all values as strings and would try to convert to other types as appropriate. Version 3 uses manifest typing. While the core functionality was very similar (ie making queries and getting values), SQLite 3 has added more non-query functionality like virtual tables, VFS, blob I/O, backup API, FTS, Rtree, ICU etc. > Nevertheless, version 3 can read the files made by version 2. No it can't. The file formats are different. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktw2+UACgkQmOOfHg372QQpxACfcbQKOrTTGkVvtriBWJv2w6X7 ZVYAoM78Bs1FWp/T2jBcXMCBRYnw6DXV =1ROr -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
