Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
nvarchar empty string: " " not ""
I figured it out. Thanks for the assistance. A helpful link is http://support.microsoft.com/?kbid=229088&sd=msdn I did the following which works: m_variant.ChangeType(VT_NULL); cmdPtr->Parameters->Append(cmdPtr->CreateParameter(bstr_t(m_name), ADODB::adBSTR, ADODB::adParamInput, m_length...- intersan
- Post #5
- Forum: Microsoft SQL Server: Programming
-
nvarchar empty string: " " not ""
I am not sure how to set a value to null. I am using code like this: cmdPtr->Parameters->Append(cmdPtr->CreateParameter(bstr_t(m_name), ADODB::adBSTR, ADODB::adParamInput, m_length, parameter->m_variant)); How do I add a NULL parameter? intersan- intersan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
nvarchar empty string: " " not ""
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...- intersan
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
