How to display binary values

sheshou

I have a field with many numbers. I don't know what type to save into the database. Currently, I plan to save it in binary, but how can I restore it to text when it is read out?

lj0917

http://dotnet.aspx.cc/article/j9ubrver-l3vb-49m3-gou1-z6c2pvr6fz3k/read.aspx

--Save like this, of course, it can be restored after display

fanfan1980

Consider text, ntext

zxm1030

Use cast to convert
select cast (field name as varchar) from tableA.
If you want to visit
select cast (field name as varchar) as name from tableA Then you can access name.