TPT Bulk Loader Teradata Pentaho - is not loading accented chars

Database
Fan

TPT Bulk Loader Teradata Pentaho - is not loading accented chars

I am not sure if you guys have heard about a Pentaho component called TPT Bulk Loader Teradata, basically It load a file on  Teradata using MLODA.

 

The file is on UTC-8 charset and it has columns with accented values, such as "á", "Ç", "ã" , etc.

The column on Teradata was defined as "COL_NAME VARCHAR(10) CHARACTER SET LATIN CASESPECIFIC"

Well, now the problem.

Lets say that in column A into the file we have the word "Informática" with the "a" accented.

The transformation ran ok and load the information, but when I queried the DB I have got "Informática" and not "Informática" as expected.

Any idea?

 

I already have tried to change the charset to UTF8, but it does not worked. 

 

I appreciate your help.

 

Thank you guys

 

1 REPLY
Teradata Employee

Re: TPT Bulk Loader Teradata Pentaho - is not loading accented chars

Did you edit the generated script (control file) before running it?

 

USING CHARACTER SET UTF8 DEFINE JOB ...