skip to main content
Connection property descriptions : ConvertNull
  

Try DataDirect Drivers Now

ConvertNull

Purpose

Controls how data conversions are handled for null values.

Valid values

0 | 1

Behavior

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 this is 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 the data type of the column value.

Data source method

setConvertNull

Default

1

Data type

Int

See also

Data type handling properties