Character large object
From Wikipedia, the free encyclopedia
A Character Large Object (or CLOB) is a collection of character data in a database management system, usually stored in a separate location that is referenced in the table itself. CLOBs are typically text exceeding 4000 characters in length[citation needed]. Oracle, IBM DB2 UDB and iSeries DB2/400 provide a construct explicitly named CLOB, and the majority of other database systems support some form of the concept, often labeled as text or long character fields.
CLOBs usually have very high size limits, on the order of 2GB or more. The tradeoff for the capacity is usually limited access methods. In particular, some database systems limit certain SQL clauses, such as LIKE or SUBSTRING from being used on CLOBs.
Alternative methods of accessing the data are often provided, including means of extracting or inserting ranges of data from the CLOB.
Database systems vary in their storage patterns for CLOBs. Some systems always store CLOBs as a reference to out-of-table data, while others store small CLOBs in-table, changing their storage patterns when the size of the data grows beyond a threshold. Other systems are configurable in their behavior.
CLOBs are distinguished from BLOBs by having a specified character encoding.
 |
This database software-related article is a stub. You can help Wikipedia by expanding it. |
