SQL Editor Query Java Object saved into VARBINARY column

84 views Asked by At

I have a 'varbinary' column where a java Properties object (Extends Hashtable) is being saved in the binary format. If I just query and convert to VARCHAR the value I get is still an un-queryble format

select CAST(myBinaryColumn AS VARCHAR(max)) from myTable;

The result is something like:

¬ísrjava.util.Properties9Ðzp6>˜LdefaultstLjava/util/Properties;xrjava.util.Hashtable»%!Jä¸F loadFactorI [email protected]

How do I convert this into something usable in a query or at least human readable?

0

There are 0 answers