[sqlite] Right way to store binary data into a blob

[Tim Streater]

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