Regarding C API for SQLITE database -


is there chance insert/retrieve image file into/from sqlite database using c api? if suggest me code me using following methods

int sqlite_encode_binary(const unsigned char *in, int n, unsigned char *out); int sqlite_decode_binary(const unsigned char *in, unsigned char *out); 

?

no, sqlite won't read file you. have read data memory yourself, insert table (you possibly use memory-mapped files - see createfilemapping on windows, mmap on linux). easiest way perhaps use parameterized query - see sqlite3_bind_blob.


Comments