I am trying to load extended ASCII data (below is sample data) using TPT script, load is failing with "TPT10508: RDBMS error 6706: The string contains an untranslatable character." error, I have tried using CHARACTER SET UTF8, LATIN1_A0, LATIN1252_3A0 and LATIN1251_0A but failed with same error message.
Expect with ASCII, using CHARACTER SET ASCII I was able to load successfully but data looks garbage "Coolâ„¢ Start", does anybody have idea or know what is the correct character set to load extended ascii data or TPT doesn't support ascii data.
$ tbuild -f tbuild_tpt.txt
Teradata Parallel Transporter Version 13.00.00.00
Execution Plan generation started.
Execution Plan generation successfully completed.
Job log: /opt/teradata/client/13.0/tbuild/logs/srimitta-9.out
Job id is dsadm-9, running on ABC
Teradata Parallel Transporter SQL DDL Operator Version 13.00.00.00
DDL_OPERATOR: private log not specified
DDL_OPERATOR: connecting sessions
DDL_OPERATOR: sending SQL requests
DDL_OPERATOR: TPT10508: RDBMS error 6706: The string contains an untranslatable character.
DDL_OPERATOR: disconnecting sessions
DDL_OPERATOR: Total processor time used = '0.03 Second(s)'
DDL_OPERATOR: Start : Sun Jun 9 15:17:08 2013
DDL_OPERATOR: End : Sun Jun 9 15:17:09 2013
Job step MAIN_STEP terminated (status 12)
Job dsadm terminated (status 12)