There is an example provided in 8i Documentation for Convert function.
SELECT CONVERT('Groß','US7ASCII', 'WE8HP') "Conversion" FROM DUAL;
But when you try to execute the same query on the DB. It does not return Gross instead it returns other characters.
and so on.
Is there any prerequisite to have a specific character set for the same. I have tried using WE8ISO8859P1, WE8MSWIN1252, UTF8 and US7ASCII