Sorry if this is terribly obvious, but I'm assuming that, in SQLite3, we can't use the sqlite_exec convenience API to store BLOBs, right?
Correct. The only way to insert a BLOB is using sqlite3_prepare() followed by sqlite3_bind_blob().
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565