Blob data...
Posted: Fri Jan 08, 2010 3:27 pm
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.
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.