Jump to content

SQL Database with blob/binary/hex data which contains rich text => conversion to string in a readable text

Stefan Pussamsies

Recommended Posts

Hi all,


i have a SQL Database which has a column which contains blob/binary/XML Data, e.g.0x3C703E4465736372697074696F6E206F66206576656E743C62723E3C2F703E.

I would like to convert this to text like "Description of event" in my Spotfire Reports.

Attached a Screenshot of the Information Link.


Do you know a solution to make this work


Thank you very much.


Kind regards,



PS: i tried Base64Encode/Decode, change the format in Spotfire from blob to string. a conversion function i have found on google was only converting hex to decimals, what did not work as i have string data.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...