Darren Duncan wrote: > > Looking inside the 'foo' database that the DBD::SQLite tests produced, with a > text editor to see its raw form, I noticed that the beginning of the file > says: > > ** This file contains an SQLite 2.1 database ** > > Should this line in fact contain a higher number? > > In particular, from an earlier compatability discussion we had on this list, > it was stated that the SQLite 2.6.0+ file format is different than the one > used before, implying that SQLite 2.1.0 thru 2.5.6 wouldn't be able to read > it. > > Therefore, should the text in the file instead say this?: > > ** This file contains an SQLite 2.6 database ** > > Or can SQLite 2.1.0 in fact read a 2.8.12 data file? >
This is explained at http://www.sqlite.org/fileformat.html section 3.1.
> Page 1 begins with the following 48-byte string: > > ** This file contains an SQLite 2.1 database ** > > A frequent question is why the string says version 2.1 when (as of this > writing) we are up to version 2.7.0 of SQLite and any change to the second > digit of the version is suppose to represent a database format change. The > answer to this is that the B-tree layer has not changed any since version > 2.1. There have been database format changes since version 2.1 but those > changes have all been in the schema layer. Because the format of the b-tree > layer is unchanged since version 2.1.0, the header string still says version > 2.1. >
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
