So I am trying to write/insert something into a database table (the DB is SQL Server).
One column contains very long strings therefore the corresponding column in the database table has the type “text”.
But it seems I cannot map a Knime Type to the Database type “text” in the DB Insert/Write Node.
When I am trying to write into the DB I am getting the error:
ERROR DB Writer 0:34 Execute failed: Error while adding rows #-100 - #0, reason: String or binary data would be truncated.
This problem didnt occur with the legacy Nodes.
Somebody can help?