Unexpected type: SQL_BLOB; (zero-based)

2 次查看（过去 30 天）
Aji Resindra Widya
Aji Resindra Widya 2017-11-20
回答： raym 2020-8-3
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.

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by