Re: display symbol in sqlplus

From: Mindaugas Navickas <>
Date: Wed, 21 Oct 2009 18:27:19 -0700 (PDT)
Message-ID: <>


WE8ISO8859P1 codepage does not support TM (174) symbol - please take a look here 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

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

Mike Navickas
Oracle&DB2 DBA 

From: Ravi Gaur <>

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

2 rows selected.


- Ravi

Received on Wed Oct 21 2009 - 20:27:19 CDT

Original text of this message