I have a sqlite database from which I want to extract a column of information with the datatype BLOB. I am trying this:

SELECT cast(data as TEXT) FROM content

This is obviously not working. The output is garbled text like this:

x��Uak�0�>�8�0Ff;I�.��.i׮%�A��s�M

The data in the content column is mostly text, but may also have images (which I recognized could cause a problem if I cast as TEXT). I simply want to extract that data into a usable format. Any ideas?

Edit
Report