Varbinary To VarChar

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

Yes you can. Here is an example:

declare @vb varbinary(12)

set @vb = 0x5375726520796F752063616E

select convert(varchar(12),@vb)

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Hunterwood SSCrazy Points: 2074 More actions · Answer 2

You can, but you need to take care about nul-values (i.e. ASCII NUL = char(0).), because these seem to act as string terminator:

declare @bin varbinary(20)

-- Converting to and from binary

set @bin = cast('Te' as varbinary(10)) + cast('st' as varbinary(10))

select @bin as [myBin], cast(@bin as varchar(20)) as [myChar]

--Result:

--myBinmyChar

--0x54657374Test

-- Test with a CHAR(0) in the middle of the binary string; the string is cut.

set @bin = cast('Te' as varbinary(10)) + cast(char(0) as varbinary(1)) + cast('st' as varbinary(10))

select @bin as [myBin], cast(@bin as varchar(20)) as [myChar]

--Result:

--myBinmyChar

--0x5465007374Te

/Markus