How to set MSSQL destination field to empty value
I am trying to set an empty value "" over the MSSQL-Adapter and Scribe converts it to NULL in the Insert or Update statement. So if the Table does not allow NULL i will receive an error.
The source value is empty and not NULL. When I try this with the NAV Adapter, Scribe inserts the empty value, but this is not an option for the amount of data.
Are there any hidden options for the SQL Adapter, to get rid off this behavior ? Because, at my point of view, NULL = NULL and not Empty=NULL.
Thanks in advance for any idea.