Good morning\evening everyone!
i have a string in a format like "0x0SD30SV8GN48N84GN"
wich represent a byte array... how can i turn that on a actual byte[]
?
the actual string is quite longer.
It represents a string in UTF-8 format that im trying to convert to UTF-32
...
what i want is to turn that to a human readble string... is that possible?
PS: The scenario is: my colleague stored a string in a varbinary column... executed a "Select myVarBinaryColumn FROM mytable" and sent me the result as txt... i need to convert to a human readble string...
PS2: the string can be understand as the result of the following operation: Cast('Hello World' as varbinary(max))