MATLAB Answers

Unexpected type: SQL_BLOB; (zero-based)

14 views (last 30 days)
Aji Resindra Widya
Aji Resindra Widya on 20 Nov 2017
Answered: raym on 3 Aug 2020
I am working with database and I am having trouble retrieving binary blob data into matlab workspace. I have a database that has some tables. In one of the table has a column that has float32 binary blob as its type. Previously when I was using python, it is easy to even just retrieve the binary blob. But in matlab I'm getting this error:
Error using
matlab.depfun.internal.database.SqlDbConnector/fetchRows
Unexpected type: SQL_BLOB; (zero-based) column index: 0;
details: initVecVarVecFromSqldbTypes().
This is the approach I use to open the database and fetch the specific column:
conn = sqlite('database.db');
data = fetch(conn,'select data from keypoints where image_id=1');
Is the zero-based blob causing this problem? Is there any way to retrieve that kind of blob to matlab? Thank you.

Answers (1)

raym
raym on 3 Aug 2020
sqlite interface only support several basic data type.
To access blob, you may use database function to create a connect object.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!