Migrate Cyrillic Database

[mlauber71]

Have you tried to use a simple example? Information in Russian characters stored in a KNIME table and then try to insert that into the MySQL database? In your screenshot I can see HTML code. Question is if the connector behaves in a different way if HTML is involved.

There was a thread some time ago where @thor suggested to add a line to the knime.ini. But there was no mentioning of a solution for the problem. Also the DB in question was MySQL.

-Dfile.encoding=UTF-8

Database(MySQL) Writer node error

uft8mb4 only means that the database is able to store all kinds of UTF-8 sequences. However it seems the strings you are trying to store is not valid UTF-8. If  you are using Windows the default charset is CP1252 and not every CP1252 string is automatically a valid UTF-8 string. You can try to add -Dfile.encoding=UTF-8 to your knime.ini (at the bottom). Also if you post your workflow we could check whether we can work around such situations automatically.