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 ;