The maximum number of bytes to display in records for fields of LOB data types.

Data Type

int

Default Value

2000

Remarks

When querying columns with a LOB data type (BLOB, CLOB, NCLOB, etc.), the server truncates all bytes in excess of the number specified in this connection property for each record in the query results.

If this connection property is set to 0 or a negative value, the default value (2000 bytes) is used.

Note: If the application integrating the server (whether it is your own code or a separate tool integrating the server) retrieves query results from a ResultSet object using the getLob or getBlob getter methods, this connection property is ignored.