数据库中建立一个表表中有一列为Image 数据类型为image 怎么填写其值啊

#2

aei1352010-07-16 14:46

可以插入二进制数据,比如0X开头的数据

#3

gameohyes2010-07-16 21:28

以下是一张图片的二进制: （用程序去进行操作吧,自己写的话....)
0xFFD8FFE15BF345786966000049492A00080000000B000E01020020000000920000000F01020005000000B20000001001020009000000B80000001201030001000000010000001A01050001000000C20000001B01050001000000CA0000002801030001000000020000003201020014000000D2000000130203000100000002000000698704000100000002010000A5C407001C000000E6000000922500002020202020202020202020202020202020202020202020202020202020202000534F4E5900004453432D54373030000048000000010000004800000001000000323030393A30343A30342031343A33333A3439005072696E74494D0030333030000002000200010000000101010000001E009A82050001000000700200009D82050001000000780200002288030001000000020000002788030001000000A00000000090070004000000303232310390020014000000800200000490020014000000940200000191070004000000010203000291050001000000A802000004920A0001000000B00200000592050001000000B802000007920300010000000500000008920300010000000000000009920300010000001D0000000A92050001000000C00200007C920700AC220000C802000000A00700040000003031303001A00300010000000100000002A0040001000000400E000003A0040001000000B00A000005A00400010000007425000000A30700010000000300000001A30700010000000100000001A40300010000000000000002A40300010000000000000003A40300010000000000000006A40300010000000000000008A40300010000000000000009A4030001000000000000000AA403000100000000000000000000000A00000040060000230000000A000000323030393A30343A30342031343A33333A343900323030393A30343A30342031343A33333A3439000300000001000000000000000A0000003A000000100000006A02000064000000534F4E59204453432000000028000020070001000000000000000030070048010000B6040000
等等,还省略了8/7.

#4

jksu2010-07-19 12:17

可以用openrowset或者 bulk insert 插入二进制值

#5

dearwolf41282010-07-20 17:35

img类型的列，需要保存为二进制码，不行你就转成二进制码就好了

数据库中建立一个表 表中有一列为Image 数据类型为image 怎么填写其值啊