SQL CLOB is a built-in type that stores large character objects as column values in a row of a database table.

By default, drivers use SQL locator(Clob) to implement Clob objects, which means that CLOB objects contain logical pointers to SQL CLOB data, not the data itself. A Clob object is valid during the transaction that created it.

Built-in types refer to the types defined by any language at the early stage of design, such as int, double and char in C language. It is also the most basic type of language, which has a great relationship with the code compiled by the compiler.

Extended data

Operation of CLOB in JAVA

In most cases, CLOB has two uses.

1, which is relatively small, can be operated directly with strings, and CLOB can be regarded as a string type.

2. If it is large, you can use getAsciiStream or getUnicodeStream and the corresponding setAsciiStream and setUnicodeStream.

In some database systems (such as SQL Server), Text is also used as an alias for CLOB.

Baidu encyclopedia -CLOB

Baidu Encyclopedia-Built-in Type