SQL & PL/SQL

Hi Team,

we are facing an issue with one of the special characters in Oracle Database:

1. We have description with ® in description
2. We have the database charset as UTF8
3. The setting for the application is Unicode
4. When we query the item on the Application, SQL Developer, the description shows fine
5. When we run the query connecting to the UNIX server with the charset UTF8, the description shows fine.
6. When we run the query connecting to the UNIX Server with the charset ISO-8859-1:1998 (Latin-1, West Europe), the description shows ® instead of ®.
7. The character value in the database shows as 49838.
8. When we check for the query SELECT CHR (49838) FROM DUAL in SQL developer, the output shows as ®
9. When we check for the query SELECT CHR (49838) FROM DUAL with the UTF8 as charset then the output shows as ®
10. When we check for the query SELECT CHR (49838) FROM DUAL with the ISO-8859-1:1998 (Latin-1, West Europe) as charset then the output shows as ®
11. We have also tried copying the character ® from charmap and using it in the description and even then it shows as ® when connected to UNIX using the charset ISO-8859-1:1998 (Latin-1, West Europe)

Can anyone confirm the char value for ® in UTF8.

Thanks

Madhavi Gadicherla