Daniel K wrote:

I think there might be something, but I can't remember exactly. It might be:

INSERT INTO tbl VALUES ( X'ABCD' );

where ABCD is the hex representation of the blob data.

If you do a ".dump" command from the shell on a
database that contains blobs and look at the output it
might prove illuminating.


Right, Dan. I forgot about that. You can insert a BLOB using sqlite3_exec() if you first encode the BLOB as a hexadecimal blob constant.


-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565



Reply via email to