I am trying to execute the following code
value = L"Test13Digit++";
SQLPrepare(stmt, L"delete Entries where [type] = ?", SQL_NTS);
SQLBindParameter(stmt, paramNumber, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WVARCHAR, 100, 0, (SQLPOINTER) value.c_str(), 0, &strLen);
the table entries is as follows:
Entries ([type] nvarchar(100), [key] nvarchar(100), [version] bigint, [data] varbinary(8000), CONSTRAINT PK_Entries PRIMARY KEY([type], [key]))
I keep getting the 22001 - string data, right truncation error. I have tried all different versions of WCHAR types but does not seem to help.
View Complete Post