--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Will Leshner wrote: > > 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? > >
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. Dan. _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com