Talend collation issue in mysql I am using Talend to backup MS SQL to MySQL Server. Everything goes well, I have a connection, data flows from one db to the other... however I cannot correctly copy diacritic signs.

On MS SQL I have Polish_CI_AS and on MySQL I have Latin2 general_ci.

When I tried to copy data from MS SQL to an Excel file, everything is in place.
I concluded that problem lies in MySQL.

Have you encountered this issue before?
In Talend MysqlOutput -> Component window -> Advanced settings. Add the following: 

"useUnicode=true&amp;characterEncoding=latin2"