SQLite Forum

How to use BLOB in C program
Login
You send a blob as a bound parameter using `sqlite3_bind_blob` just as you would use any of the `sqlite3_bind_<datatype>` functions.  Similarly you would retrieve a blob column using `sqlite3_column_blob` just as you would use any of the `sqlite3_column_<datatype>` functions.  The interfaces are quite similar to the functions for handling text, except that you of course need to set or get the data size since blobs are not 0 terminated.

<https://sqlite.org/c3ref/bind_blob.html>  
<https://sqlite.org/c3ref/column_blob.html>