How exactly do I fix an error related to 'untranslatable character'

Database
N/A

How exactly do I fix an error related to 'untranslatable character'

I've found several posts regarding the same topic of an untranslatable character, but don't know how to fix the problem.

Both my target and source tables have Latin encoding on the column that I think is the problem. However, I'm still getting an error regarding this untranslatable character. I can't figure out 100% if this is related to the incoming data, but is there still a way to go around this? I've read to check the Translate_with_error (what's the exact name?) and translate_chk functions, but what do I do with them?

Tags (1)
2 REPLIES

Re: How exactly do I fix an error related to 'untranslatable character'

Have you  tried something like this?

Select   Col1

,     Translate_Chk(Col1 using Latin_To_Unicode)

,     Col2

,     Translate_Chk(Col2 using Latin_To_Unicode)

,     Col3

,     Translate_Chk(Col3 using Latin_To_Unicode)

...

from  yourtable

Where (

      Translate_Chk(Col1 using Latin_To_Unicode) <> 0

or    Translate_Chk(Col2 using Latin_To_Unicode) <> 0

or    Translate_Chk(Col3 using Latin_To_Unicode) <> 0

or    ....

      )

Teradata Employee

Re: How exactly do I fix an error related to 'untranslatable character'

This should fix this issue.

TRANSLATE( ColumnName USING LATIN_TO_UNICODE WITH ERROR);