Return
-
Title
Failed inserting from row ... without detailed row number info : [Teradata Database] [6706] The string contains an untranslatable character -
Description
When importing from a Excel XLSX (XLS or CSV are a problem too) into Teradata one may see the error:
Failed inserting from row #0 to #394 without detailed row number info : [Teradata Database] [6706] The string contains an untranslatable character
-
Resolution
WORKAROUND 1:
To set all VARCHAR fields to the Unicode character set. However, when toad creates the table from the import wizard, it uses Latin character set.
WORKAROUND 2:
Creating the table before importing, and considering this example:CREATE MULTISET TABLE quest_test.MT_Courses, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO (column_var_1 VARCHAR(52) CHARACTER SET UNICODE NOT CASESPECIFIC,column_var_2 INTEGER,column_var_3 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,column_var_4 DATE FORMAT 'DD-MM-YYYY')NO PRIMARY INDEX ;STATUS:
Waiting to be fixed in a future release of Toad Data Point.
-
Defect ID
QAT-11470