Embedded zeros terminate BLOB's about matlab-sqlite3-driver HOT 2 CLOSED

I can't reproduce such behavior. Are you treating BLOB as a string somewhere?

>> sqlite3.open('test.sqlite3');
>> sqlite3.execute('CREATE TABLE records("blob" BLOB)');
>> sqlite3.execute('INSERT INTO records VALUES (?)', zeros(1,10,'uint8'));
>> record = sqlite3.execute('SELECT * FROM records')

record = 

    blob: [0 0 0 0 0 0 0 0 0 0]

If you wish to save a Matlab variable, you might want to check a serialize function at https://github.com/kyamagu/matlab-serialization

from matlab-sqlite3-driver.

Thanks for the speedy answer.
Checking the differences between your example and what I wrote up, I found
the culprit:
I was indeed trying to just use a string indeed. I guess I was too used to
using strings for binary data in Lua :).
Using uint8 instead does work.

Kind regards,

Jan-Pieter

2013/11/18 Kota Yamaguchi [email protected]

I can't reproduce such behavior. Are you treating BLOB as a string
somewhere?

sqlite3.open('test.sqlite3');
sqlite3.execute('CREATE TABLE records("blob" BLOB)');
sqlite3.execute('INSERT INTO records VALUES (?)', zeros(1,10,'uint8'));
record = sqlite3.execute('SELECT * FROM records')

record =

blob: [0 0 0 0 0 0 0 0 0 0]

If you wish to save a Matlab variable, you might want to check a serializefunction at
https://github.com/kyamagu/matlab-serialization

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/1#issuecomment-28708176
.

from matlab-sqlite3-driver.