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.