Stupid Question 169: LOB, BLOB and CLOB - what are those?
LOB, when storing large objects :)
Try saying that fast 10 times! I was talking on Skype with a friend that is learning programming, and we started talking about storage and SQL server. I mentioned BLOB and after a giggle was asked what that is. For a short definition, this is how I explained it:
LOB stands for Large Object and it’s a data type that are for storing large objects. BLOB stands for Binary Large Object and is in binary format- and it’s not uncommon to see images stored that way. CLOB stands for Character Large Object and allows us to store string data in database character set format. Often BLOB is used to refer to both BLOB and CLOB
The nest question is, should we store large images as BLOB’s, or save them on a filesystem and store the path instead? That question is coming up very soon, but I would love to hear what you think :)
Last modified on 2013-03-26