0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professionals and students of engineering

DECLARE @hexString VARCHAR(MAX)
SET @hexString = '0xFFD8FFE000104A46494600010101004800480000FFED003C43524541544F5220536F6674776172650050494343205049432057484F4C454441595741594944002C1C00000000134D45444941444D3150323031352D30342D31375431353A34343A35312B30323A30300A003300010100020000001E00000014436F6C6F7253706163652057696E646F777300323031383A30333A30372031303A31333A3339000100000000A0020014000000323031383A30333A30372031303A31333A3339000000000000000000000014000A00000002000200000000000000000000003C56455253494F4E20504943445F4E4F544946590000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'
-- Your hexadecimal string here

DECLARE @binaryData VARBINARY(MAX)
SET @binaryData = CONVERT(VARBINARY(MAX), @hexString, 1)

DECLARE @varcharData VARCHAR(MAX)
SET @varcharData = CONVERT(VARCHAR(MAX), @binaryData, 0)

SELECT @varcharData AS ConvertedData

fork query

edited mar 4

created apr 18 11 anonymous