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

Data Type

bool

Default Value

false

Remarks

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.

This property is useful for normalizing blank fields in text files to null values during import.