TDS_EMPTY_STRING_IS_NULL Option [database]

Controls whether empty strings are returned as NULL or a string containing one blank character for TDS connections.

Allowed Values

ON, OFF

Default

OFF

Description

TDS_EMPTY_STRING_IS_NULL is set to OFF by default and empty strings are returned as a string containing one blank character for TDS connections. When this option is set to ON, empty strings are returned as NULL strings for TDS connections. Non-TDS connections distinguish empty strings from NULL strings.