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

2010-10-28 Thread Art Age Software
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 ru

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

2010-10-27 Thread Art Age Software
NED 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 aff

[sqlite] Loss of Binary Data in Dump File

2010-10-27 Thread Art Age Software
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 probl