Character set [message #50207] |
Wed, 06 March 2002 03:03 |
James Briar
Messages: 72 Registered: January 2002 Location: Morden (South London)
|
Member |
|
|
How can you find out what character set a database is currently using. We've a database created with a character set WE8IS08859P1 but how could i find this out if i didn't know. Where using Oracle 8i on Unix (Sun Solaris 8).
Thanks.
|
|
|
Re: Character set [message #50217 is a reply to message #50207] |
Wed, 06 March 2002 07:23 |
Kassim Kasmani
Messages: 25 Registered: January 2002
|
Junior Member |
|
|
Hello,
The following views will help:
v$nls_parameters
nls_database_parameters
nls_instance_parameters
nls_session_parameters
Hope this helps!
__________________________
Kassim Kasmani
Yahoo Messenger: kassim13
|
|
|
|
Re: Character set [message #50270 is a reply to message #50217] |
Fri, 08 March 2002 02:35 |
Vijay
Messages: 116 Registered: September 1999
|
Senior Member |
|
|
You can use V$Parameter views. But, there are 2 more methods to find out.
1. See the NLS_LANG parameter set in your system.
2. If you don't have rights to see them, then connect with sql*plus prompt and then give
@%nls_lang%
|
|
|