display symbol in sqlplus

  • From: Ravi Gaur <ravigaur1@xxxxxxxxx>
  • To: oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Oct 2009 17:41:30 -0500

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: