Re: [sqlite] SQLite 3 file format changed?
Firman Wandayandi [EMAIL PROTECTED] wrote: Hi, I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite 3.3.4 library, then PDO said error message like unsupported file format. I tried to use sqlite3 console which is version 3.2.6 for open it, same error message given. I suspected there was file format has been changed again, but I can't found any log on http://sqlite.org/changes.html told about that. What's wrong exactly? Version 3.3.0, 4th bullet: More efficient coding of boolean values resulting in a smaller database file -- D. Richard Hipp [EMAIL PROTECTED]
Re: [sqlite] SQLite 3 file format changed?
On 2/20/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Version 3.3.0, 4th bullet: More efficient coding of boolean values resulting in a smaller database file -- D. Richard Hipp [EMAIL PROTECTED] Oh that's it! But seems doesn't like file format log changed :-) On 2/20/06, Jens Miltner [EMAIL PROTECTED] wrote: 3.3 changed the database format, but can read/write any 3.x format. However, once you create or vacuum a database with 3.3.x, the format is updated to the newest format and older implementations can't read it any more. See http://sqlite.org/formatchng.html for details I just found it. Nice 3.3 can read/write 3.x, but no PDO_SQLITE updated yet ATM, the latest is 3.2.8, so the problem is PDO_SQLITE then I need to wait someone updated it. Thanks for the infos. -- Firman Wandayandi Never Dreamt Before: http://firman.dotgeek.org/ Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9
[sqlite] SQLite 3 file format changed?
Hi, I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite 3.3.4 library, then PDO said error message like unsupported file format. I tried to use sqlite3 console which is version 3.2.6 for open it, same error message given. I suspected there was file format has been changed again, but I can't found any log on http://sqlite.org/changes.html told about that. What's wrong exactly? -- Firman Wandayandi Never Dreamt Before: http://firman.dotgeek.org/ Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9