0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

declare @x varbinary(20), @y varbinary(20);
set @x = cast(N'Hello' as varbinary(20));
set @y = cast('Hello' as varbinary(20));
select @x, @y;
select cast(@x as nvarchar(20)) as x_unicode, 
cast(@x as varchar(20)) as x_ascii,
cast(@y as nvarchar(20)) as y_unicode, 
cast(@y as varchar(20)) as y_ascii
;

fork query

edited jan 16 19

created apr 18 11 anonymous