untranslatable character error teradata


untranslatable character error teradata

I am getting error of untranslatable character in teradata as target table definition is LATIN.I changed my source stage table definition to UNICODE.Now that particular record is getting inserted.

But I can't insert this data from this table to another target table as that target table definition is LATIN only.(And I can't change that table definition to unicode as its being used by other application).

Can anyone please suggest me some way to check any unicode character and replace it with another default latin character.?

or can anyone please suggest me any unix script to do so ?