Did your PDO SQLite unable to read and write database that you just created using your SQLite console? And PDO said something like "unsupported file format", didn’t you?
“Hey what’s up man?”
“You’re not a lucky guy my friend, me either”
Did you know that the SQLite file format has changed again? At January 10th, 2006 exactly the file format changed to version 3.3, here is the log for it:
Version 3.3.0 uses a new encoding for binary values that uses less disk space. Version 3.3.0 can read and write database files created by prior versions of SQLite. But prior versions of SQLite will not be able to read or write databases created by Version 3.3.0
for complete file format logs, you can read here. Additional log can found on the complete SQLite changes log.
“We’re soo late my friend, it’s more than one month ago”
Current PDO uses SQLite library version 3.2.8undefined, not weird if it unable to works with your SQLite databases those created by SQLite 3.3.x console.
This time and only this time, just use your SQLite 3.2.x console in order to makes your PDO SQLite working properly and your databases safe while waiting for new PDO released. Don’t made any mistakes with open your SQLite created by PDO using SQLite 3.3.x console, if you won’t frustated and don’t get PDO wrong if it happened to you.
“You has been noticed man!“
2 Comments