BLOB and CLOB

Database
Enthusiast

BLOB and CLOB

Hi,

What are large objects? Can you please lemme know the prominence of an BLOB an CLOB(Binary and Char Large objects)?

Thank You
2 REPLIES
Enthusiast

Re: BLOB and CLOB


Two Types of Large Object (LOB) data type in Teradata. LOB's are mainly used to define columms that require to store data greater than 64K in length. The maximum size of a single LOB is approximately 2 GB (2,097,088,000). The LOB data is not stored physically with the data row in same block but is stored separately in a LOB subtable. The size of LOB is not counted against the maximum row length.
The base table row contains a pointer (called the Object Id, or OID). The OID points to the subtable row containing the LOB data.

Binary Large Object (BLOB) : Store Raw Binary data same like VARBYTE but can be defined as 2 GB in length, can be used to store images, video clips and word documents etc.

Character Large Object (CLOB): Store character data same like VARCHAR, such as simple text, HTML, or XML documents.

Re: BLOB and CLOB

Hi,

Could you explain how to insert an image on a table from SQL Assitant?

My_Table (ID Char(10,Image_File BLOB)

Thanks for your help!!