Hello all, I was hoping that someone might share some tips on working with Blobs? I would like to be able to store some images and sound files in a database, but never having dealt with them, I am kind of at a loss for some examples. I have looked on the web, and there are few examples that were of use.
My impression from what I have seen is that Blobs are dealt with in a different way than other data types. Am I correct in assuming that Blobs need to be created explicitly, and then you repeatedly call 'sqlite3_blob_write()' to store them, and 'sqlite3_blob_read()' to read them? Also, can you have a select statement that retrieves regular data as well as blob data in the same query? Anyone have a good place for me to start? Thanks, Mike _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users