I want to know what does Oracle's CLOB has to offer over BLOB data type. Both have data storage limits of 4GB.
A text string which is longer than 4000 bytes can not fit in VARCHAR2 column. Now, I can use CLOB and BLOB as well to store this string.
Everyone says, CLOB is good and meant for character data and BLOB is for binary data such as images, unstructured documents.
But I see I can store character data inside a BLOB as well.
What I want to know :
So, question is on the basics, why CLOB and why not BLOB always? Is there anything to do with encoding ?