I have a situation in which data (mostly images) is stored in a BLOB. As you know data in BLOB are guid like which I cannot relate to any file. My question is, is there a way by which I can extract the real path, file name etc of that particular BLOB. The idea behind this question is to create an extra table in which I will list the blob values and associate with them the file name etc... EXAMPLE:
BLOB Value1| ASCII Value1|BLOB Value2| ASCII Value2|BLOB Value3|ASCII Value3
1123123 | C:\ | 324234 | picture |345345453 | .jpg
Please note I am a newbie in this area just finished installing my first BLOB