CLOB

Stands for "Character Large Object." A CLOB is a data type used by various database management systems, including Oracle and DB2. It stores large amounts of character data, up to 4 GB in size. The CLOB data type is similar to a BLOB, but includes character encoding, which defines a character set and the way each character is represented. BLOB data, on the other hand, consists of unformatted binary data.

Common data types used for storing character data include char, varchar, and text. Some database management systems also support additional text data types such as tinytext, mediumtext, and longtext. If the standard character data types are not large enough for a certain database field, the CLOB data type may be used. Since CLOB data may be very large, some database management systems do not store the text directly in the table. Instead, the CLOB field serves as an address, which references the location of the data.

CLOBs provide a way to store unusually large amounts of text, such as an entire book or publication. However, some database programs cannot run certain text operations on CLOB fields, such SQL commands with the "LIKE" condition. Therefore, it is often better to use other character data types for smaller text values.

Updated July 9, 2009

Definitions by TechTerms.com

The definition of CLOB on this page is an original TechTerms.com definition. If you would like to reference this page or cite this definition, you can use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about the CLOB definition or would like to suggest a new technical term, please contact us.

Want to learn more tech terms? Subscribe to the daily or weekly newsletter and get featured terms and quizzes delivered to your inbox.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.