Converting binary data back to original form

ozzii · #1 (**permalink**) 01-09-11, 15:30

Hi,

I have a table which has word or pdf documents stored as Blobs. The table also has a field which identifies the content type i.e. (application/ms-word, application/octet-stream, text/plain) and another field which identifies the orginal filename.

table as follows:

Code:

 CREATE TABLE `tbl_myfiles` (
	`FileID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
        `FileName` VARCHAR(50) NULL DEFAULT NULL,
	`FileSize` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
	`ContentType` VARCHAR(50) NULL DEFAULT NULL,
	`BinaryData` MEDIUMBLOB NULL,
        PRIMARY KEY (`FileID`)
)

Is there a way in Mysql to convert this data back to its original form and save it to a folder?

it-iss.com · #2 (**permalink**) 01-10-11, 04:19

There is nothing in MySQL directly but this can be done programatically in PHP. I have put together some code sample to show how this can be done in PHP. Check out the following link MySQL – Inserting and reading BLOB’s in PHP « IT Integrated Business Solutions

Internet Services

Web Development

Digital Marketing

Consumer Tech