topic Multibyte character to/from teradata in Talend Studio

Multibyte character to/from teradata

sszzxx — Sat, 16 Nov 2024 07:27:38 GMT

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!

Re: Multibyte character to/from teradata

Anonymous — Tue, 16 Oct 2018 08:00:37 GMT

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

Re: Multibyte character to/from teradata

sszzxx — Tue, 16 Oct 2018 10:10:16 GMT

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.

Re: Multibyte character to/from teradata

Anonymous — Tue, 16 Oct 2018 10:14:34 GMT

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

Re: Multibyte character to/from teradata

sszzxx — Wed, 17 Oct 2018 02:24:00 GMT

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!