Need help in insert a huge file as a blob into SQL Server DB

1 次查看（过去 30 天）
JFz
JFz 2015-12-22
评论： Rebecca Krosnick 2015-12-24
Hi,
I have a huge file that is a matrix. The size of the matrix change daily, but always around 100MG.
I need to insert it into a Sql Server database as a blob. How to do that?
I read the data insert from this site but still need help here, since it is different from all other inserts.
Thanks a lot.
Jennifer
  1 个评论
Rebecca Krosnick
Rebecca Krosnick 2015-12-24
What commands are you currently trying to use? Do you experience any errors?
You should use the "fread" function to read the binary data from the MAT file. You can then insert the binary data as a BLOB object into the database using the an insert function.
Note that the Native ODBC interface does not support the BLOB datatype, but the JDBC driver does.

请先登录，再进行评论。

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

回答（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!

Translated by