Google News
logo
JDBC - Interview Questions
Tell us about the data types CLOB and BLOB in JDBC.
Character Large OBjects (CLOBs) is a data type (internal character object) used to store large objects. When selecting a value of any LOB type, a pointer is returned via the SELECT statement, and not the value itself; In addition, LOB types can be external. This data type is suitable for storing textual information that may fall outside the normal VARCHAR data type (upper limit of 32 KB).
 
An internal blob (BLOB) is a large binary object that can contain a variable amount of data. This data type can store data larger than VARBINARY (32K limit). A type of data intended primarily for storing images, audio and video, as well as compiled program code.
Advertisement