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 interface:
>
> http://php.
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
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 to the bottom of this
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 colum
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 co
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
-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 con
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 MESSAGE-
> Hash: SH
-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 sto
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
10 matches
Mail list logo