Hello to the Knime community,
I am having a problem with the “DB writer” node when I’m trying to add rows into a MySQL DB: when I check the table in the DB, special Polish or Turkish characters are replaced by “?” on import. I checked the encoding and collation for the specific column in the DB I am trying to import these characters to, and they are set to UTF8, utf8_general_ci respectively.
And indeed when I try to add these characters myself to the column, they are correctly interpreted and accepted by the DB.
So I suspect the problem comes from the DB writer itself, which does not process UTF8 encoding when adding new rows to the DB. I searched Knime forums and someone had a very similar issue to mine a while ago: mysql character encoding problem
The solution is apparently to add
jdbc:mysql://:/<database_name>?useUnicode=true&characterEncoding=utf8
to the “SQL URL” but I have no idea where to make that change, or even if one can still make that change in the latest version of Knime. Any help would be greatly appreciated.
Thank you!
Cheers,
Berti