Insert byte slice into sqlite blob

Question

I try to insert a slice of bytes into a sqlite3 database, using github.com/mattn/go-sqlite3.

Data:

thmbnail := [255 216 255 219 0 132 ...]

Create statement:

sqlStmt := `
create table result (id INTEGER NOT NULL PRIMARY KEY, fname TEXT, path TEXT, 
size INTEGER, fMDate TEXT, fUUID TEXT, fSHA1 TEXT, fPRONOM TEXT, fNSRL INTEGER, fTHMB BLOB);
pragma journal_mode=WAL;
delete from result;
`

Insert:

func addEntryDB(stmt *sql.Stmt, entry fileMD) {

    _, err := stmt.Exec(nil, entry.fName, entry.fPath, entry.fSize, entry.fMDate,
    entry.fUUID, entry.fSHA1, entry.fPRONOM, entry.fNSRL, entry.fTHMB)
    if err != nil {
        log.Fatal(err)
    }
}

Problem: Only the first four bytes of thmbnail are inserted. I suppose this might be related to the 0 byte on the fifth position.

How can the whole []byte be inserted?

This might be related. But the bug should be fixed stackoverflow.com/questions/29452538/… — Steffen
– Steffen, Commented Jun 9, 2017 at 22:03

Steffen · Accepted Answer · 2017-06-10 21:02:57Z

1

I found the problem. It sat before the monitor.The data was inserted actually. Sqlite client handles the blob as text and terminates printing at the "0". Inspecting the database with sqlitebrowser showed the complete entry.

answered Jun 10, 2017 at 21:02

Steffen

7332 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert byte slice into sqlite blob

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related