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.
I already have tried to change the charset to UTF8, but it does not worked.
I appreciate your help.
Thank you guys