TPT Bulk Loader Teradata Pentaho - is not loading accented chars

Database
N/A

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

 

2 REPLIES
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 ...

 

N/A

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

yeah, we have tryed. 

 

When we set UTF8 as charset, the information is loaded ok, but for some unknown  reason some records are rejecteds, for example for the string "FERRAMENTAS E CONSTRUÇÃO", I think it is because of the "Ç" maybe the "Ã", we are still looking for some solution.

 

The error code on those cases is 6705. I am still looking for an solution.

Any Idea?

 

I appreciate, thanks

Fabio