Re: display symbol in sqlplus
- From: Mindaugas Navickas <mnavickas@xxxxxxxxx>
- To: ravigaur1@xxxxxxxxx, oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Oct 2009 18:27:19 -0700 (PDT)
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@xxxxxxxxx>
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
Other related posts:
