note 110595 added to ref.pdo-sqlite

Instead of compiling an old version of SQLite to create a database using an older database format that the version of SQLite bundled with PDO can handle, you can (much more easily) just run the query "PRAGMA legacy_file_format = TRUE;" BEFORE creating the database (if you have an existing database, run ".dump" from the sqlite shell on your database, run the sqlite shell on a new database, run the PRAGMA, then paste the contents of the .dump). That will ensure SQLite creates a database readable by SQLite 3.0 and later. ---- Server IP: 69.147.83.199 Probable Submitter: 67.246.140.55 ---- Manual Page -- http://www.php.net/manual/en/ref.pdo-sqlite.php Edit -- https://master.php.net/note/edit/110595 Del: integrated -- https://master.php.net/note/delete/110595/integrated Del: useless -- https://master.php.net/note/delete/110595/useless Del: bad code -- https://master.php.net/note/delete/110595/bad+code Del: spam -- https://master.php.net/note/delete/110595/spam Del: non-english -- https://master.php.net/note/delete/110595/non-english Del: in docs -- https://master.php.net/note/delete/110595/in+docs Del: other reasons-- https://master.php.net/note/delete/110595 Reject -- https://master.php.net/note/reject/110595 Search -- https://master.php.net/manage/user-notes.php