CodingIsFun
Programmer
Hi all experts,
Does anyone know how to convert a varbinary field into readable text?
thanks in advance...
Does anyone know how to convert a varbinary field into readable text?
thanks in advance...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
varbinary conversion to text?
- Thread starter CodingIsFun
- Start date
- Status
Take a look at this
--this will make it varbinary
SELECT CONVERT(VARBINARY(31),'Wasabi')
this will make it plain text again
SELECT CONVERT(VARCHAR(31),0x576173616269)
Denis The SQL Menace
SQL blog:
Personal Blog:
--this will make it varbinary
SELECT CONVERT(VARBINARY(31),'Wasabi')
this will make it plain text again
SELECT CONVERT(VARCHAR(31),0x576173616269)
Denis The SQL Menace
SQL blog:
Personal Blog:
- Status
Similar threads
- Locked
- Question