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?
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.