Both ASE and MS SQL Server can implicitly convert a (var)binary
to a string, but ASE can also implicitly convert a string to a (var)binary
, whereas this is impossible on MS SQL Server.
Example
declare @c varchar(20), @b varbinary(20)
set @c = 0x1234abcf
set @b = @c
select @b