I've got a temporary database with a blob column. I'm using the PHP PDO
interface, and I'd like to store some binary data into the blob; it's actually
an image. Later I'm going to read it back and write it to disk. What's the
right way to get the data into the column? At the moment I'm using str_replace
to change any single-quote to two single-quotes, and then doing as follows:
$dbh->query ("update imagetable set imagedata='" . $bd . "' where linkid=" .
$linkid);
but this is giving me:
SQLite error: general code: HY000 error: 1, unrecognized token: "'����/�Exif"
Seems to me my approach is wrong.
Thanks,
--
Cheers -- Tim
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
