Character Interpretation
I am having some issue with the interpretation of special characters by Oracle
One of my function returns a string based on a input number. This string can contain special characters as well (some of which are actually 2 byte like CHR(50053) which should return Å).
But when I try to run this function in Toad/SQLDeveloper , it is returning an inverted question mark/square box respectively.
What is more baffling is that when I run the same function in another schema of the SAME database , it returns the correct character value. Is there any schema level setting to control the same ?? (which doesnt look the case as select chr(50053) from dual is working correctly in the erraneous schema.)
Any pointers will be really appreciated...