How to write to postgres column type text or varchar(255)

[Alice_Krebs]

Hi @niederle

have you tried mapping the text to e.g. nvarchar? Did that work?
Maybe that forum post helps:

Does the DB Insert/Write Node have a mapping option for text?

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 trunca…

Best,
Alice