I am new on this forum.We try to use Poco library to manage a MS SQL Server 2008 Database and so we use Poco::Data and Poco::Data::ODBC api.I am using Poco 1.4.2 version and we have noticed a problem when we try to insert EMPTY string:

Question mark is the standard way to pass parameters in. What version are you using? If you are using trunk code, it could be that your column is non-nullable and "emptyStringIsNull" feature is enabled.

In any case, you can easily work around it by formatting the SQL query:

I think is better with placeholder.I have tried with non-nullable and nullable Column but it is the same. Where could I find the option "emptyStringIsNull"? Is it an option of SQL SERVER Column or Poco C++?