How to save structure in SQLITE C ++

Question

I am trying to save simpel struct (vector3) in sqlite3_bind_blob, but I have no idea how this works. If I debug this code, it will end the console window. How can I fix this problem?

struct vector3 { int X; int Y; int Z; }; int main () { sqlite3 *db = NULL; sqlite3_stmt *res = NULL; sqlite3_open_v2("SaveGame1.sav", &db, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL); string query = "CREATE TABLE IF NOT EXISTS TestPlayer (vector BLOB)"; sqlite3_prepare_v2 (db, query.c_str(), query.length(), &res, 0); sqlite3_step(res); // Try to add mij struct vector3 MyLocation; MyLocation.X = 100; MyLocation.Y = 100; MyLocation.Z = 100; query = "INSERT INTO TestPlayer (location) VALUES (?);"; sqlite3_prepare_v2 (db, query.c_str(), query.length(), &res, 0); sqlite3_bind_blob (res, 1, &MyLocation, sizeof(vector3), SQLITE_TRANSIENT); sqlite3_step(res); query = "SELECT * FROM TestPlayer;"; sqlite3_prepare_v2 (db, query.c_str(), query.length(), &res, 0); sqlite3_step(res); const vector3 *GetLoc = (const vector3 *) sqlite3_column_blob(res, 0); cout << GetLoc->X << endl; sqlite3_finalize(res); sqlite3_close(db); return 0; } 

Answer 1

I believe sqlite3_column_blob() should be used for the results of a query operation. Try a query for the data you just pasted