Encoded Images

frederickstoll posted 3 months ago in General

Does anyone know how to retrieve an image from HeidiSQL once it has been encoded?

kalvaro posted 3 months ago

Do you know what method or algorithm was used to encode the image?

frederickstoll posted 3 months ago

I know the database field is a longblob I converted an image using base64 and then I put that data into the longblob field, and now the data doesn't look the same. I don't know if HeidiSQL or MySQL changes the data, but it isn't exactly what I entered

kalvaro posted 3 months ago

You should run something like this:

SELECT FROM_BASE64(your_column_name)

... and then enable the Image preview feature in Grid view options. You need MySQL/5.6 or greater.

Please login to leave a reply, or register at first.