Multibyte character to/from teradata

Highlighted
Six Stars

Multibyte character to/from teradata

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:

 

Capture.JPG

 

Under the file setting I have also set it to UTF-8:

tfile_properties.JPG

java_setting.JPG 

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!

 

 


Accepted Solutions
Highlighted
Six Stars

Re: Multibyte character to/from teradata

Hi All,

 

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

 

Capture_1.JPG 
Thanks all for the help!

View solution in original post


All Replies
Highlighted
Employee

Re: Multibyte character to/from teradata

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

Highlighted
Six Stars

Re: Multibyte character to/from teradata

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.

 

 

Highlighted
Employee

Re: Multibyte character to/from teradata

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

Highlighted
Six Stars

Re: Multibyte character to/from teradata

Hi All,

 

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

 

Capture_1.JPG 
Thanks all for the help!

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now