Controls whether empty strings are returned as NULL or a string containing one blank character for TDS connections.
ON, OFF
OFF
By default, TDS_EMPTY_STRING_IS_NULL is set to OFF 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.