Just get a pointer to the data in the file and the number of bytes and use the sqlite API call to transfer it into the DB. You can get the pointer by either reading the file into local memory or by mmap'ing it. Also look at the API calls which let you process a blob in chunks.
A BLOB is called a Binary Large OBject because it accepts anything. Fred J. Stephens wrote: > Mike McGonagle wrote: >> Hello all, >> I was hoping that someone might share some tips on working with Blobs? > I am also curious about this. > For instance, how can I store a file in a table? > Not read the file and store the text, but the binary file itself? > Thanks. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
