Specifies whether empty values should be interpreted as empty strings or as NULL.

Data Type

bool

Default Value

false

Remarks

This property applies to SELECT operations.

When PushEmptyValuesAsNull is set to false, empty values are pushed as an empty string for VARCHAR columns, 0 for numeric fields, and NULL for date fields.

When set to true, the provider pushes empty values returned from the query operation as NULL.