Multibyte character to/from teradata

[sszzxx]

Hi All,

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!

[Anonymous]

Hi,

    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 🙂

Warm Regards,

Nikhil Thampi

[sszzxx]

Hi Nikhil,

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.

[Anonymous]

Hi,

      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?

Warm Regards,

Nikhil Thampi

[sszzxx · Accepted solution]

Hi All,

I have solved it by adding the appropriate charset that I need for my case as shown below (highlighted):

 
Thanks all for the help!