tDBinput Mysql writes strange characters (not latin) in tDBOutput mysql

[lucfarm]

Hi everyone,

I inserted 2 components in my Designer area, a tDBInput and a tDBoutput in order to get data from an exernal DB and insert this data into another database.

Both databases have collation utf8_general_ci. I inserted inside the component parameters &characterEncoding=UTF-8 (I tried also &characterEncoding=utf8), but when I check data on my target DB, some fields with non latin characters are written with strange symbols (see the screenshot).

What did i do wrong?

[lucfarm]

Hi Nikhil,

none of these posts helped me. I searched on google, but i don't remember
the link where I found the solution. I'm sorry.

[Anonymous]

@lucfarm 

My request is to mark your own post where you have outlined the solution. This will help other Talend community members during their reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved