SQL Blobs, converting it to fileformat using Matlab

3 次查看（过去 30 天）
Stan
Stan 2013-6-18
Hello,
I was playing around with SQL Server and BLOBS/Filestream. I have not worked with it before but thought it might be useful to add some document references to a few GUIs (and to properly store various documents).
Anyway, I stored a pdf into SQL. Then I query it within Matlab: Data=fetch(conn, SELECT * FROM FilestreamTest);
Output: FileBLOB: {[1733701x1 int8]}
It provides me with the data. However, I have a few questions: 1) Is it possible to derive original file format (pdf in this case) or should I save it as extra information in the database? 2) How to convert it to, in this case, a PDF?
Thank you.

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

采纳的回答

Friedrich
Friedrich 2013-6-18
编辑：Friedrich 2013-6-18
Hi,
  1. no you can't. save that as additional information
  2. use fopen, fwrite, fclose to write the int8 values back as .pdf file:
fid = fopen('out.pdf','w')
fwrite(fid,1733701x1 int8 Values,'*int8')
fclose(fid)

更多回答（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