RDBMS code 6706: The string contains an untranslatable chara

nikhil_bhasin · Post by **nikhil_bhasin** » Mon Jun 17, 2013 5:46 am

I am also facing similar issue. Was anyone able to resolve this?

crystal_pup · Post by **crystal_pup** » Mon Jun 17, 2013 6:24 am

1) Identify the column on which the error is encountered. Check the character set associated with that column in Teradata. If its LATIN, change it to UNICODE (UNICODE takes much space though).
2) In the Teradata Connector stage, change the character set to UTF8 and then try re-running the job.

nikhil_bhasin · Post by **nikhil_bhasin** » Tue Jun 18, 2013 4:51 am

@crystal_pup
Are you saying to change the table definition?
That field is defined as LATIN, if I use UTF-8 in terdata connector, the job simply aborts but when I change it to ASCII, then it replaces those characters with space/some other charcaters

crystal_pup · Post by **crystal_pup** » Tue Jun 18, 2013 5:22 am

Hi Nikhil

Yes, change the column character set to UNICODE in the table definition.

Regards