posted 10 years ago
Hi Ulf Dittmer and Paul,
Thanks a lot for you response.
I found one solution to convert the text with funky characters.
In stored procedure iam using convert('Character set','UTF8'), this solved my requirement.
Oracle has nearly the following character sets (as per I know, ofcourse I googled )
US7ASCII, WE8ISO8859P1, EE8MSWIN1250, WE8MSWIN1252, WE8EBCDIC1047, JA16SJISTILDE, ZHT16MSWIN950, AL32UTF8, UTF8
Now I would like to convert into UTF8 whatever the character set it is.
So any one can help me out. How I can achieve this requirement in oracle.
Thanks in advance.