SQLite Forum

how to insert a structure data into blob?
> there is no error message, the code is complied ok

Sure, it compiles, but the code you have shown us does not check the results of any of the calls to sqlite functions. Please re-read my previous response: your INSERT does not comply with your schema, so cannot work for reasons having nothing to do with the blob.