Unexpected type: SQL_BLOB; (zero-based)
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
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.
0 件のコメント
参考
カテゴリ
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!