Re: [sqlite] Loss of Binary Data in Dump File

Thank you. I'll investigate some code change options. On Sat, Oct 30, 2010 at 5:33 PM, Simon Slavin wrote: > > On 30 Oct 2010, at 10:29pm, Stephen Chrzanowski wrote: > > > Please post how you manage to get PHP to use Sqlite3 without PDO > > There is yet another SQLite

Re: [sqlite] Loss of Binary Data in Dump File

On 30 Oct 2010, at 10:29pm, Stephen Chrzanowski wrote: > Please post how you manage to get PHP to use Sqlite3 without PDO There is yet another SQLite interface: http://php.net/manual/en/book.sqlite3.php It's object-oriented, so of you don't already use OO in PHP you're going to have to learn

Re: [sqlite] Loss of Binary Data in Dump File

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 wrote: > With Roger's help I have gotten

Re: [sqlite] Loss of Binary Data in Dump File

On 28 Oct 2010, at 8:28am, Art Age Software wrote: > 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

Re: [sqlite] Loss of Binary Data in Dump File

Art Age Software 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

Re: [sqlite] Loss of Binary Data in Dump File

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

Re: [sqlite] Loss of Binary Data in Dump File

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/27/2010 02:20 PM, Art Age Software wrote: > I guess the next question is how do I force the affinity to "blob" The affinity is the type that SQLite will make a reasonable attemp to convert to for that column, but leave the value as is if the

Re: [sqlite] Loss of Binary Data in Dump File

Thanks Roger. That does seem to be the problem as the type of the columns is coming back as "text." I guess the next question is how do I force the affinity to "blob" using the PHP PDO API... Sam On Wed, Oct 27, 2010 at 2:12 PM, Roger Binns wrote: > -BEGIN PGP SIGNED

Re: [sqlite] Loss of Binary Data in Dump File

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/27/2010 11:48 AM, Art Age Software wrote: > New to this list and hoping someone can help. I have a sqlite3 > database that contains a couple of tables that have binary data in > BLOB columns. Note that there is column affinity, but the data

[sqlite] Loss of Binary Data in Dump File

Hi All, New to this list and hoping someone can help. I have a sqlite3 database that contains a couple of tables that have binary data in BLOB columns. I know the data is in there and stored correctly because the application accessing the database can retrieve the column data just fine. The