I am using the following query to find out columns that have untransalatable characters:
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?