Using the Database Writer to Insert into MySQL Longtext fields

I am trying to use the Database Writer to insert data into a MySQL database table that contains the a field of data_type "longtext".

However I am experiencing the following error:

Execute failed: Column "approach_desc" of type "StringCell" from input does not match type "VARCHAR" in database at position 2

Is there a way to get this data into the table via KNIME, or is this data_type not supported?  Thank you for the help



Hi, this is the same problem I described in my post

My workaround is to create a new record with the "smaller" sized fields and the use the Database Update node to insert the long text. This is annoying but works until the problem is eventually solved. Apparently the Update node does not have the same problem as the Writer node.

Best regards Jerry


1 Like