On 9 Nov 2015, at 7:52pm, gwenn <gwenn.kahz at gmail.com> wrote: > Could you please confirm that BLOBs created by > sqlite3_bind_blob64()/sqlite3_bind_zeroblob64() can still be read with > sqlite3_blob_read()/sqlite3_blob_bytes() or sqlite3_column_blob > /sqlite3_column_bytes() because their size can never exceed the limit > specified here:
Yes, you can mix and match these routines. Make sure you use the right size for your pointers, and are using hardware, OS and programming language which can handle pointers of that size and that amount of memory. Make sure you close your BLOB handles before trying to read/replace your values atomically. A BLOB handle should not, ideally, be held open which waiting for input from users or an external device. But it will still work correctly as long as thing else tries to mess with the field or row before the handle is closed. Simon.
