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? 

4 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

Teradata Employee

Re: Removing all occurrences of Untranslatable Character

where can I find the udf_checklatin udf ?

Highlighted
Teradata Employee

Re: Removing all occurrences of Untranslatable Character

The Unicode ToolKit is available from http://downloads.teradata.com/download/tools