Re: display symbol in sqlplus

Ravi, 

WE8ISO8859P1 codepage does not support TM (174) symbol - please take a look here http://en.wikipedia.org/wiki/ISO/IEC_8859-1 for supported symbols in this codepage.
TM symbol would be in WE8MSWIN1252 codepage.  

Unless you would have all strings that store TM in NCHAR/NVARCHAR2 datatype. 
If you are on Oracle10, please take a look in this document http://www.oracle.com/technology/tech/globalization/pdf/TWP_Character_Set_Migration_Best_Practices_10gR2.pdf

Display of characters also depend what settings you have on client site (NLS_LANG, NLS_CHARACTERSET) as well if fonts do support required characters.

Regards
Mike Navickas
Oracle&DB2 DBA 




________________________________
From: Ravi Gaur <ravigaur1_at_gmail.com>

Hello,
Can someone pl. provide any pointers on how to display the Trademark symbol in sql*plus (™) ?
We can get the registered symbol (ascii 174) show up but not the trademark (ascii 153).

The NLS settings in the db are as follows --
SQL > select parameter,value from nls_database_parameters where parameter like '%CHARACTERSET';

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8ISO8859P1
NLS_NCHAR_CHARACTERSET         AL16UTF16

2 rows selected.


TIA,

- Ravi

--
http://www.freelists.org/webpage/oracle-l