Extracting photos from MySQL?

Question

PHP

Greetings.
I inherited a MySQL database with photos that are in a column with the VARBINARY type. Maybe someone will tell you how to properly convert them to base64 and then insert them into the img tag. Tried through base64_encode, but it didn't help. Perhaps some other modifications are needed?

screenshots of data in a column

Column type:
Data in cells:

Answer 1

Judging by the fact that at the beginning there is a signature FF D8 FF E0 - this is a JPEG picture. Only here is its presentation, well, very atypical, well, or, this is how the Binary Editor strangely displays data. What data is in the column in "raw" form?

Answer 2

All transformations are in the code that writes the photo to the database.

Answer 3

what's the point of your screenshot
, be it in text form, at least it was clear what kind of image format in the database

Answer 4

Have you tried casting VARBINARY -> CHAR at the base level?

SELECT CAST(binaryColumn as CHAR) from table_name