I am writing a C++ application using ADO to manage an SQL Server dbase.
The database is set to compatibility version 80.
If I set an nvarchar field to an empty string ""; it is stored in the dbase as a
single space string: " ". I need it to be an empty string in the dbase so I can distinguish between an empty string and a single space string.
I am using the SQLOLEDB connector. According to the help that came with SQL Enterprise manager, if the dbase is set to compatibility level 70 or 80 then
"The empty string literal (' ') is interpreted as an empty string."
But it does not to make a difference.