Yes, that's correct. 🙂

And if you want to keep the data in default varbinary format and display it in character when selecting then last statement can be changed to display in varchar e.g.

select cast(binaryField as varchar(max)) from @temp

select convert(varchar(max), binaryField, 0) from @temp