It is not very common to query the character set modification Character Set of oracle.
Query the character set of Oracle
Method 1
SQL> select userenv ('language') from dual;
Userenv ('language ')
------------------
American_america.we8iso8859p1
Method 2
SQL> select * from V $ nls_parameters;
Parameter Value
--------------------------------------------
Nls_language American
Nls_territory America
Nls_currency $
Nls_iso_currency America
Nls_numeric_characters .,
Nls_calendar Gregorian
Nls_date_format DD-MON-RR
Nls_date_language American
Nls_characterset we8iso8859p1
Nls_sort binary
Nls_time_format HH. Mi. ssxff AM
Nls_timestamp_format DD-MON-RR HH. Mi. ssxff AM
Nls_time_tz_format HH. Mi. ssxff am tzr
Nls_timestamp_tz_format DD-MON-RR HH. Mi. ssxff am tzr
Nls_dual_currency $
Nls_nchar_characterset al16utf16
Nls_comp binary
Nls_length_semantics byte
Nls_nchar_conv_excp false
Modify Character Set
Connect system/Oracle10g as sysdba;
Update props $ set value $ = 'utf8' where name = 'nls _ characterset ';
Shutdown immediate;
Startup Mount;
Alter system enable restricted session;
Alter system set job_queue_processes = 0;
Alter system set aq_tm_processes = 0;
Alter database open;
Alter database character set internal_use utf8;
Alter database National Character Set internal_use utf8;
Shutdown immediate;
Startup;
This is not very common. Please note.