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?