display symbol in sqlplus

From: Ravi Gaur <ravigaur1_at_gmail.com>
Date: Wed, 21 Oct 2009 17:41:30 -0500
Message-ID: <289232290910211541r688bf026ub8b3e9edbd794baa_at_mail.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

Received on Wed Oct 21 2009 - 17:41:30 CDT