The Oracle character code modification

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
      May when installing Oracle, we forget the selection of coding, and installed it, and found the default encoding is not what we need, then how do we modify the Oracle character set? Need to use the Oracle built-in sqlplus command to connect at the same time, using the command to perform the operation, can complete the modification.
    Such as the need for the Oracle character set is modified as ZHS16GBK, as follows
sqlplus sys as sysdba

SQL>shutdown immediate;                
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use ZHS16GBK;
SQL> shutdown immediate;
SQL> startup

     Now we command to query whether successful modification:
select userenv('language') from dual;

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Connie at December 16, 2013 - 8:44 AM