Blob data...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Wolf_22
Forum Contributor
Posts: 159
Joined: Fri Dec 26, 2008 9:43 pm

Blob data...

Post by Wolf_22 »

I have around 50 or so records in my database that contain blob information. This was inserted here from an application that stored files in the database and apparently, these "blobs" are the contents of those files.

A recent migration / upgrade issue occurred and now whenever we try to download those files from the database, the files come back with nothing in them. Ha.

Given I know what format the files could be in, is there anyway I can take the blob string and re-convert this back to the Word or text document it was originally in prior to being inserted into the database or am I simply screwed? If I lose the files, then shame on me and I can live on from this loss, but I would like to avoid it even if it means taking each string and converting it back 1 by 1.

My understanding of blob was that it represented the actual human-version of the information you've stored in the database, but only in binary format. Stupid me--I took one of the blob strings and tried to convert it to ascii! Ha.

Any ideas here? Help is very appreciated. :)
Post Reply