On 29 Dec 2009, at 2:02am, Zaher Dirkey wrote: > Pavel Ivanov wrote: >> > >> Just keep in mind that if the user puts blob column into a query >> (which IIRC is required by SQLGetData) then SQLite reads full blob >> value into memory before you can do anything with that. So you're not >> with a good luck here anyway. > > If i want to extract BLOB to a file that mean it is must the whale > blob be loaded to memory before can save it?
Yes. Also, the whole BLOB must have been in memory in the first place, when you saved the record. When you INSERT or SELECT a record the whole record exists in memory. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
