skip to main content
Using the JDBC Client : JDBC Connection Properties : ConvertNull
 

ConvertNull

Description

Controls how data conversions are handled for null values.

Valid Values

1 | 0
If set to 1, the JDBC Client checks the data type being requested against the data type of the table column storing the data. If a conversion between the requested type and column type is not defined, the JDBC Client generates an "unsupported data conversion" exception regardless of the data type of the column value.
If set to 0, the JDBC Client 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.

Default

1

Data type

int