Am 20.02.2006 um 06:33 schrieb Firman Wandayandi:
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?
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