Error:
Reverse Engineering from Teradata getting error:
<Level=1><Warning> REDB-1022: Database error: [Teradata][ODBC Teradata Driver][Teradata Database](-6706)The string contains an untranslatable character.
Solution:
This issue could be caused when the character set defined while creating the target table is incompatible to load data extracted from the Source. Here the issue was that the Column was defined with Character set as Latin and data to be loaded contained Unicode characters. Most likely the character set of your source table differ from your target table. If your source table contains unicode character fields which also contains real unicode values and your target table field is defined as latin character set you will get this error code.
To resolve this issue, ensure that the source and target DB/tables character set are compatible. To load Unicode characters into the columns, recreate the target table with column character set changed from Latin to Unicode.
