Removing all occurrences of Untranslatable Character

Database
Enthusiast

Removing all occurrences of Untranslatable Character

I am using the following query to find out columns that have untransalatable characters:

SEL msg,

translate_chk (  msg using LATIN_TO_UNICODE) as pos 

FROM Msgtbl WHERE pos<>0;

I am finding the initial position of the untranslatable character.

I want to remove all occurences of the untranslatable characters in the msg string.How can I do  this? 

2 REPLIES
Enthusiast

Re: Removing all occurrences of Untranslatable Character

Any answers to this?

-- Jonny
Teradata Employee

Re: Removing all occurrences of Untranslatable Character

The udf_checklatin udf in the Unicode Tool Kit should resolve this issue.

 

 

-Dave