The length is given in number characters for both CLOB, unless one of the suffixes K, M, or G is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively.
Length is specified in characters (Unicode) for CLOB.
A CLOB without a specified length is defaulted to two giga characters (2,147,483,647).
java.sql.Clob
CLOB
Use the getClob method on the java.sql.ResultSet to retrieve a CLOB handle to the underlying data.
See