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

Data Type

bool

Default Value

true

Remarks

Indicates whether empty values should be interpreted as empty strings or as NULL. This setting only affects SELECT statements when UseBulkAPI = true and BulkAPIVersion = v2.

By default, the driver pushes empty values returned from the BULK V2 API query operation as NULL. When PushEmptyValuesAsNull is set to false, empty values are instead pushed as an empty string for VARCHAR columns and as 0 for numeric fields.