how to export data to txt format?

[mlauber71]

How about you use the CSV writer and change the extension to .txt

CSV Writer (deprecated)

You could adapt the separator:

You could also adapt the encoding

And since we are at it - you can change the standard encoding in KNIME:

Migrate Cyrillic Database

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