Explanation of a BLOB and a CLOB

Question

I am looking for a real good explanation of a BLOB and CLOB data. I am looking for the great of that explains in plain English.

Answer 1

A BLOB is a Binary Large Object which can hold anything you want including images and media files. Anything stored as a binary file.

A CLOB is a Charactor Large Object, which will hold charactors (text), Basically this makes it a huge string field. CLOB also supports charactor encoding meaning it is not just ascii charactors.

The two links to Oracle's FAQ will provide specific information for the usage of each.