Answer the question
In order to leave comments, you need to log in
How to accept BLOB data from MS SQL in MySQl?
The photo lies in MS SQL in the field of type IMAGE. You need to pass it to MySQL in a BLOB field.
Is the MySQL function correctly written, which is called on the MS SQL side to write to MySQL:
CREATE FUNCTION insert_photo(_img BLOB) RETURNS INT
BEGIN
INSERT INTO Photo(img) VALUE(_img);
return LAST_INSERT_ID();
END
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question