I have tried to export data from Teradata to a csv file with Chinese character. However I am getting junk (->) instead of the chinese char as shown below:
Under the file setting I have also set it to UTF-8:
Despite all these, I am still getting those junk characters in my csv output file.
Can somebody please help??
The simple job im doing is basically tTeradataInput to tFileOutputDelimited.
Thanks in advance!
Solved! Go to Solution.
Could you please share the schema of the tTeradataInput Component? I guess you are using VARCHAR in the DB type? Could you please change it to the DB data type within the Teradata table and let us know the results?
If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)
Thanks for your reply.
I have managed to figure it out. Guess it was the tTeradata component that was giving the issue.
I have added the following charset (SCHGB2312_1T0) and now it is finally supporting Chinese characters.
Good one :-)
Could you please add a screen shot of the chnage you made in the Teradata component so that it will help our Talend community members? Could you please also mark the topic as resolved (with your answer as the solution) so that it can be easily referred in future?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks