SQLServer and empty strings

[JBird]

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.

Thanks,

JBird

[nimmow]

I know this sounds silly, but your c++ code doesnt have a space between the ''s does it? make sure in your code you are placing '' and not ' ' ...

[Rune Bivrin]

Use the SQL Profiler to see what the SQL that's submitted actually looks like.

Rune