SQLite3:在C++中插入带有NULL字符的BLOB

#include<sqlite3.h>

sqlite3 *db;
sqlite3_open("test.db", &db);

char *errorMessage = 0;
const char *sql = "CREATE TABLE IF NOT EXISTS blobs (id INTEGER PRIMARY KEY, data BLOB);";
sqlite3_exec(db, sql, NULL, 0, &errorMessage);

const char *blobData = "This is a BLOB with a NULL character: \0";
int blobSize = strlen(blobData);

sqlite3_stmt *stmt;
const char *insertSql = "INSERT INTO blobs (data) VALUES (?)";
sqlite3_prepare_v2(db, insertSql, -1, &stmt, NULL);

sqlite3_bind_blob(stmt, 1, blobData, blobSize, SQLITE_STATIC);
sqlite3_step(stmt);
sqlite3_finalize(stmt);

sqlite3_close(db);