SELECT * FROM nls_database_parameters where parameter = 'NLS_CHARACTERSET';

-----Original Message-----
From: Edwin Uy
[mailto:oracledba-ezmlmshield-x8166612.[Email address protected]
Sent: Thursday, July 15, 2004 6:18 PM
To: LazyDBA Discussion
Subject: CHARACTER SET


HI all,

How do I check what is my db character set? Whether it is WE8ISO8859P!
or US7ASCII or whatever ... thought it should show when I do a show
parameter nls, but not getting that info doing that ...

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Our name has changed. Please update your address book to the following format: "[Email address protected]

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.


Oracle LazyDBA home page