How can I transfer binary data (pictures) over the network from MSSQL to MySQL 5.7?

Question

MySQL

In MSSQL, photos are stored in a field of type IMAGE. In MySQL, these pictures will be stored in a BLOB field. Is it possible to transfer binary data in binary form, or is BASE64 encoding indispensable?
ps. I know that storing photos in the database is not the best idea. But that's the only way they can pass it on.

Answer 1

Did not work with MSSQL, but judging by the usual documentation, the IMAGE type in MSSQL is a regular blob. Binary data up to 2GB in size. That is, MSSQL IMAGE and MySQL BLOB must be compatible.
In phpMyAdmin, I even remember there was a choice when importing data, in the format of which particular DBMS the file that needs to be loaded into the database is presented.
So, it is quite possible to export data from MSSQL and import it into MySQL using standard methods. And you don't have to think about things like base64.