Im reading from AS400 one arabic field and inserting it into mysql DB, but it seems Im only getting gibberish with qestion marks?
Note: I tried to add into the (additional JDBC parameters) this string (useUnicode=true&characterEncoding=utf8) with no luck....
Hope someone could help.
Your Mysql db also should accept UTF-8 characters. alter your table which field you need to load arabic data.
for your reference please see below query.
ALTER TABLE `database`.`table` MODIFY COLUMN col VARCHAR(255)
CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
Have you also tried to add the "Dfile.encoding=utf-8" to the JVM parameters to see if it works?
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.