Oracle various character Set modifications

Select * The From V$nls_parameter will show the values of Nls_characterset and Nls_nchar_characterset

The methods for modifying character set Nls_characterset and Nls_nchar_characterset values are as follows:

1, modify Nls_characterset:

sqlplus "/As SYSDBA"
sql> SHUTDOWN IMMEDIATE
sql> STARTUP MOUNT
sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;
sql> ALTER SYSTEM SET job_queue_processes=0;
sql> ALTER SYSTEM SET aq_tm_processes=0;
sql> ALTER DATABASE OPEN
sql> alter DATABASE CHARACTER set Internal_use utf8;--> indicates that the character set format is modified to UTF8
sql> SHUTDOWN IMMEDIATE
sql> STARTUP

Where internal_use means skipping the character set check;

2, modify Nls_nchar_characterset:

sqlplus "/As SYSDBA"
sql> SHUTDOWN IMMEDIATE
sql> STARTUP MOUNT
sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;
sql> ALTER SYSTEM SET job_queue_processes=0;
sql> ALTER SYSTEM SET aq_tm_processes=0;
sql> ALTER DATABASE OPEN
sql> ALTER DATABASE national CHARACTER SET internal_use UTF8;
sql> SHUTDOWN IMMEDIATE
sql> STARTUP

3. Modify the lang parameter under Linux:

VI /etc/sysconfig/i18n---> Modify lang's Parameters

4. Modify the Nls_lang parameters under Linux:

CD/

VI . Bash_profile

Modifying the parameter settings of export Nls_lang

After you have finished modifying the exit, enter the following command at the command line to reset the environment

. . bash_profile

Oracle various character Set modifications