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?