SQL Server varbinary(max)到Image数据类型

时间:2021-06-01 09:25:35

I've got a database table that stores images as varbinary(max). This works great for me. However, I have to now send this data to a MS Dynamics database that will have to use the Image data type.

我有一个数据库表,将图像存储为varbinary(max)。这对我很有用。但是,我现在必须将此数据发送到必须使用Image数据类型的MS Dynamics数据库。

Is there anything I need to be aware of when saving varbinary(max) to image? Can my data become corrupted, or are they generally the same datatype for all intents and purposes?

将varbinary(max)保存到图像时是否需要注意什么?我的数据可以被破坏,或者它们通常是所有意图和目的的相同数据类型吗?

Thanks

谢谢

1 个解决方案

#1


5  

They are the same thing and handled the same internaly. They droped the image name because it dosn't really make sense. Its not like sqlserver can do image operations in tsql

它们是同一个东西,并且内部处理相同。他们对图像名称进行了调整,因为它确实没有意义。它不像sqlserver可以在tsql中做图像操作

#1


5  

They are the same thing and handled the same internaly. They droped the image name because it dosn't really make sense. Its not like sqlserver can do image operations in tsql

它们是同一个东西,并且内部处理相同。他们对图像名称进行了调整,因为它确实没有意义。它不像sqlserver可以在tsql中做图像操作