All Forums Database
Kishore_1 208 posts Joined 03/10
08 Mar 2016
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? 

You must sign in to leave a comment.