The following table summarizes connection properties which can be used to handle data types.

Table 1. Data Type Handling Properties
Property Characteristic

BinaryDescribeType

 Specifies how columns of the Binary type are described. This property affects ResultSetMetaData calls. getTypeInfo() calls are affected only when the property is set to longvarbinary. In this configuration, an additional LONGVARBINARY entry is added to the getTypeInfo results.

If set to varbinary, Binary columns are described as VARBINARY.

If set to longvarbinary, Binary columns are described as LONGVARBINARY.

The default is varbinary.

ConvertNull

Controls how data conversions are handled for null values.

If set to 0, the driver does not perform the data type check if the value of the column is null. This allows null values to be returned even though a conversion between the requested type and the column type is undefined.

If set to 1, the driver checks the data type being requested against the data type of the table column that stores the data. If a conversion between the requested type and column type is not defined, the driver generates an "unsupported data conversion" exception regardless of whether the column value is NULL.

The default is 1.

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.

If set to true, the driver uses the JVM algorithm when converting a double or float value to a string value. If your application cannot accept rounding differences and you are willing to sacrifice performance, set this value to true to use the JVM conversion algorithm.

If set to false, the driver uses its own internal algorithm when converting a double or float value to a string value. This value improves performance, but slight rounding differences within the allowable error of the double and float data types can occur when compared to the same conversion using the JVM algorithm.

The default is false.

MaxBinarySize Specifies the maximum length, in bytes, of fields of the Binary data type when described by the driver through result set descriptions and metadata methods. If a field exceeds the specified length, the driver truncates that field.

The default is 2147483647.

MaxStringSize Specifies the maximum length, in characters, of fields of the String data type as described by the driver through result set descriptions and metadata methods. This property does not affect getTypeInfo() calls. If a field exceeds the length specified by this option, the driver truncates that field.

The default is 2147483647.

StringDescribeType

Specifies whether String columns are described as VARCHAR or LONGVARCHAR. This property affects resultSetMetaData() calls; it does not affect getTypeInfo() calls.

The default is varchar.