Please post how you manage to get PHP to use Sqlite3 without PDO as I've been wrestling with that for a while now. Any time I use Sqlite commands, it creates the DB as SQLite2, not 3.
On Thu, Oct 28, 2010 at 3:28 AM, Art Age Software <artag...@gmail.com>wrote: > With Roger's help I have gotten to the bottom of this issue, and I > wanted to post the resolution to the list in case anyone else bumps > into it. > > There is a bug in PHP versions prior to PHP 5.3 that makes it > impossible to reliably create/store BLOB columns. My code ends up > creating TEXT data when run under any version of PHP in the 5.2.x > branch. When run under PHP 5.3.x, BLOB columns are correctly created. > > So, the only options are to either use PHP 5.3 or later, or to ditch > PDO and use PHP's native Sqlite3 interface directly. > > Thanks. > > Sam > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users