The following table summarizes connection properties which can be used to handle Varchar, Longvarchar, and Numeric data types.

Table 1. Data Type Handling Properties
Property Characteristic
ConvertNull Controls how data conversions are handled for null values.
JavaDoubleToString Determines which algorithm the driver uses when converting a double or float value to a string value. By default, the driver uses its own internal conversion algorithm, which improves performance.
MaxNumericPrecision Determines the maximum precision of NUMERIC columns when described within the result set metadata.
MaxNumericScale Determines the maximum scale of NUMERIC columns when described within the result set metadata.
MaxVarcharSize Determines the maximum size of VARCHAR columns when described within the result set metadata.
VarcharClobThreshold Enables CLOB functionality when handling character data. Determines whether columns of the Character varying data type will be described as VARCHAR or LONGVARCHAR (CLOB).

See also