After converting binary, try this-
select 'Your binary data is : ' + SUBSTRING( convert(nvarchar(32), @Binval,1),3,LEN(convert(nvarchar(32), @Binval,1)))
Or
Declare @binString nVarchar(32)
Set @binString=convert(nvarchar(32), @Binval,1)
select 'Your binary data is : ' + SUBSTRING( @binString,3,LEN(@binString))
Converting binary value:
@binString=convert(nvarchar(32), @Binval,0)
print @binString
@binString=convert(nvarchar(32), @Binval,1)
print @binString
@binString=convert(nvarchar(32), @Binval,2)
print @binString
Out Put of converted string :
Your binary data is : ā
Your binary data is : 010101010101010000000000000000
Your binary data is : 010101010101000000000000000000