Good evening,
Ive been dealing with blobs over the past few days, and experienced several issues with my application dealing with them. I have solved it by splitting a blob file up over multiple records, so instead of having one massive blob in a record, I now have a table:-
CREATE TABLE `fileBlob` (`fileID` BIGINT NOT NULL ,`part` INT NOT NULL ,`blob` TINYBLOB NOT NULL )
Which works great for uploading files into the table, but messy when downloading. Currently I call the statment and work through each row appending the blob output:-
SELECT * FROM `fileBlob` WHERE `fileID` =27ORDER BY `part` ASC