Enables CLOB functionality when handling character data. Determines whether columns of the Character varying data type will be described as VARCHAR or LONGVARCHAR (CLOB).
Valid Values
x
where:
x
is a number of characters.
Behavior
If the width of a Character varying column is greater than x, the Character varying data type is described as LONGVARCHAR and CLOB functionality is enabled. The driver allows you to retrieve and update long data by using JDBC methods designed for Clobs. This functionality provides random access to data and allows searching for patterns in the data. To provide these benefits, data must be cached. Because data is cached, your application will incur a performance penalty, particularly if data is read once sequentially.
If the width of a Character varying column is less than or eqal to x, the Character varying data type is described as VARCHAR. If you want to avoid the performance penalties associated with CLOB functionality, you should set this value at a value greater than the maximum Character varying column width your application handles.
