I try to use blobs as little as possible. When possible I replace blobs by a link to a file. I can only think of a few times that I needed a blob. I used to put zipped pickled python objects in there, but I use mongo or couchdb these days for that. One thing I still use it for is to store wkb (gis) objects. This made me wonder, what do other people put in their blob fields?
+2
A:
Whatever binary data needs to be stored - typically images & documents (Word, PDF).
OMG Ponies
2010-07-22 22:01:52
Binary serialized objects are another option.
Peter LaComb Jr.
2010-07-22 22:07:37
+1
A:
BLOB accepts any data, all the items stored in the BLOB are stored in whole disk pages in separate disk areas from normal row data. Normally in a BLOB you can store any data generated by your program, images, graphics, video, audio or different types of documents.
Prakash Kalakoti
2010-07-23 05:25:31
+1
A:
They have disadvantages..., so tried to ignore them, especially now file-stream exists in SQL2008.
Mr Shoubs
2010-07-23 09:21:50