How Import image from MS SQL?

2 次查看（过去 30 天）

显示更早的评论

Vladimir Malin 2018-12-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437087-how-import-image-from-ms-sql

回答： Vladimir Malin 2018-12-27

In stock:

1. MS SQL Database

2. Table of images Images

3. Running BigBase ODBC connection ('Microsoft SQL Server' driver '13 .00.1601 ')

4. Code reading photos using MatLab:

clear all;
close all;
cd 'D:\NEWDoc\MATLAB';
% Make connection to database. Note that the password has been omitted.
% Using ODBC driver.
conn = database ('BigBase', 'user', 'pass');
% Read data from database.
st = 'select top 10 RecID, Image from images';
data = fetch (conn, st);

5. The results:

RecID Image

6143047 5999x1 uint8

224233 8000x1 uint8

4200382 6130x1 uint8

13687913 8000x1 uint8

2212046 8000x1 uint8

8346866 6400x1 uint8

1305479 6760x1 uint8

7806085 6641x1 uint8

6851834 7164x1 uint8

7084710 6550x1 uint8

As you can see, some fields, when imported, are cropped to 8000x1 uint8 it turns out that when importing, large images are lost.

Why? How to fix it?

Additional Information:

In the database, the field Image type - (blob)

5 个评论
显示 3更早的评论隐藏 3更早的评论

Kojiro Saito 2018-12-26

What is the data type of Image column? Are you using varbinary or varbinary(MAX)?

Vladimir Malin 2018-12-26

[Image] [varbinary](max) NOT NULL

请先登录，再进行评论。

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

回答（1 个）

Vladimir Malin 2018-12-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437087-how-import-image-from-ms-sql#answer_354098

I personally managed to solve my problem.

But there were questions.

Solution: I used the MS SQL driver

In theory, all these drivers should work fine.

But only one MS SQL gave the correct result:

6143047		5999x1 	uint8
224233		24889x1 uint8
4200382		6130x1 	uint8
13687913	28456x1 uint8
2212046		8511x1 	uint8
8346866		6400x1 	uint8
1305479		6760x1 	uint8
7806085		6641x1 	uint8
6851834		7164x1 	uint8
7084710		6550x1 	uint8