Search code examples
unixencodingasciiteradataplaintext

Teradata error 6706 loading non printable characters

I have an ETL that creates a plain text that later will be loaded into Teradata, in the source data there is a column UTF8 enconded that has all kind of characters including non printable, I properly write the file but i get Error Code 6706: The string contains an untranslatable character.

This is the destiny column 

column VARCHAR(300) CHARACTER SET LATIN NOT CASESPECIFIC

I can load characters like this é but not characters like this ’

How can I properly write the file, and validate before sending the data, I don't have access to the data base just know that they get the error Code 6706.

Thanks in advance

Solution

  • Make column as unicode...

    column VARCHAR(300) CHARACTER SET unicode NOT CASESPECIFIC.