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 CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by