Toad World® Forums

Untranslatable Characters

Is there any way TDB could actually identify which column is having an issue? This is like looking for a needle in a haystack sometimes.

Failed inserting from row #660000 to #670000 without detailed row number info : [Teradata Database] [6706] The string contains an untranslatable character.

How are we supposed to interpret this? It seems to indicate rows were processed, there was an error, but rows were imported and committed.

Using something like the following doesn't seem to work either when the records in question are loaded into a temp table.

select
'< col >' as msg
,translate_chk ( msg using LATIN_TO_UNICODE) as pos
-- ,translate_chk ( msg using UNICODE_TO_LATIN) as pos
from '< table >'
WHERE pos<>0