6706 : The string contains an untranslatable character.

Database

6706 : The string contains an untranslatable character.

Hi,

 

I have created a table with 50+ columns and trying to insert records into that table and I am getting error code 6706 : The string contains an untranslatable character. 

 

Is there any function I can find which column is causing this problem. or Do I have to go through each column to find where this error occuring ? 

 

If I just run select statement from Insert statement it works fine.

 

Thanks!

4 REPLIES
Teradata Employee

Re: 6706 : The string contains an untranslatable character.

Provide more details on the interface being used to do the insert e.g., TPT, JDBC, fastload, BTEQ, etc.

Junior Supporter

Re: 6706 : The string contains an untranslatable character.

You will have go through each column to check which one has untranslatable character.
Look into columns defined as CHAR.
Go through knowledge article KAP1F83B6 which provides more details about this issue.


Abhishek Jadhav

Re: 6706 : The string contains an untranslatable character.

David,

 

I am using JDBC interface. 

Senior Apprentice

Re: 6706 : The string contains an untranslatable character.

You might try to create an error table for the target table and then do the INSERT/SELECT with LOGGING ALL ERRORS (I don't know if error 6706 is catched).

ETC_FieldID hopefully contains the ColumnId which can be matched to dbc.ColumnsV to get the column name.