image 值读取问题，有高手看看吗。感谢了。

Question

CREATE TABLE [YB_ZYBHADD] (
[BHID] [int] NULL ,
[DQBM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[YBLB] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[YBLSH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YBDJH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ICKH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[STATE] [int] NULL ,
[CFH] [int] NULL ,
[ICXX] [image] NULL ,
[DJXX] [image] NULL ,
[CYXX] [image] NULL ,
[JSXX] [image] NULL ,
[SFID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO YB_ZYBHADD(BHID,DQBM,YBLB,CBH,ICKH,YBLSH,STATE,DJXX, CFH) VALUES
(36900,'05','01','123456987','','34',0,'431028000001/34/201000478/胡国/1/29362//123456987/430223198005216217////////1/40190/0/A01.001/农合//0/0/0/20100112/1/1//0',0)
select * from YB_ZYBHADD查询结果发现 DXJJ=0x33313032383030303030312F33342F3230313030303437382FBAFAB9FA2F312F32393336322F2F3132333435363938372F3433303232333139383030353231363231372F2F2F2F2F2F2F2F312F34303139302F302F4130312E3030312FC5A9BACF2F2F30
在不改字段类型的情况下，用什么命令语句能读取出来吗。吧DJXX还原为插入的那样。感谢了。

Answer 1

如果保存的是二进制的内容,读出来的数据没有意义.如果是字符串,可以考虑使用:select cast(col as varchar) from tb

Answer 2

二进制内容，select方式读出来的应该就是楼主看到的结果。
如果是字符串的话，可以用cast或者convert来转换一下看看。 
另外，2005之后的版本可能不再支持image了哦！ 建议改为varchar(max)类型。

Answer 3

CREATE TABLE [YB_ZYBHADD] (
    [BHID] [int] NULL ,
    [DQBM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [YBLB] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [YBLSH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [YBDJH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [CBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [ICKH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [STATE] [int] NULL ,
    [CFH] [int] NULL ,
    [ICXX] [image] NULL ,
    [DJXX] [image] NULL ,
    [CYXX] [image] NULL ,
    [JSXX] [image] NULL ,
    [SFID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO YB_ZYBHADD(BHID,DQBM,YBLB,CBH,ICKH,YBLSH,STATE,DJXX, CFH) VALUES
(36900,'05','01','123456987','','34',0,'431028000001/34/201000478/胡国/1/29362//123456987/430223198005216217////////1/40190/0/A01.001/农合//0/0/0/20100112/1/1//0',0)
select cast(cast(DJxx as binary(8000))as varchar(8000)) from YB_ZYBHADD
drop table YB_ZYBHADD
/*
(1 個資料列受到影響)
431028000001/34/201000478/胡?/1/29362//123456987/430223198005216217////////1/40190/0/A01.001/?合//0/0/0/20100112/1/1//0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         (1 個資料列受到影響)*/

Answer 4

不允许从数据类型 image 到 varchar 的显式转换。

Answer 5

image
不能直接轉換成 varchar()
要先轉換成binary
然後再轉換成varchar()

Answer 6

Happy_Stone
 
(【石头剪子布】)  谢谢了  

Answer 7

convert(varchar(255),convert(varbinary(255),col))