Unexpected type: SQL_BLOB; (zero-based)
2 views (last 30 days)
Show older comments
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.
0 Comments
Answers (1)
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.
0 Comments
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!