In my application, earlier we were dumping 32K bytes of data into a Varchar column.
Now the size of data has increase upto 600K. The column type has been changed to BLOB. Can someone tell me what is the difference between BLOB and CLOB. And why BLOB was preferred over CLOB. Is it something related to the limits or storage space?
I read the document. Its a good information about CLOB and BLOB. But my question is why did we prefer BLOB to CLOB. And the data to be dumped in the column is actually character data. So we could use CLOB as well.
Do you know if BLOB takes some less storage or there is some other advantage over CLOB.
Internally, CLOB is varying-character string and BLOB is a varying-binary string.
The benefit of storing it in a CLOB, you can query(SELECT) the data and see what's inside it, if required for any purposes and when stored in a BLOB, i don't think you can read it so easily, since its considered as a binary.
Also, i don't think there will be any storage differences of storing the same data in CLOB and BLOB.
I cannot confirm the statement about selecting BLOB data, since i don't have any BLOB columns with data.