My project contains data from all over the world hence all languages are supported. While working with Talend, it seems there is no multi language support in it or not as robust application.

We are populating data into MySQL 5.0 and above it supports UTF-8, we are able to populate multilingual data into it. But using Talend it populates junk characters.

We had imported excel sheets with UTF-8 encoding, it displays in Preview perfectly but at the time of populating data it converts into junk characters.

We also looked at Java code behind it and try to track where it is actually converts characters, but at the time of building job it regenerate the code and all changes are gone but one thing is sure that until database connection, data is correct. something happened in DB library using in Talend.

Can anyone had the same problem, or any direction can be suggested.