Oracle 11g Character Set modification

Service-side Character Set modification 1, confirming the service-side character set

1 Select userenv ('language' from dual;

2. Modify the service-side character set to first log in to Oracle as a DBA. Run commands directly under the Windows system under the command lineSqlplus/as sysdbaor run the command under SQL PLUS/as sysdba。 Then run the command in turn:

1. Shutdown immediate; (the database was stopped)
2. startup Mount; (Re-open the database to change the situation)
3. Alter system enable restricted session;
4. alter system set job_queue_processes=0;
5. alter system set aq_tm_processes=0;
6. ALTER DATABASE open;
7. ALTER DATABASE character set Internal_use UTF8;
8. Shutdown immediate;
9. Startup (Re-open normal Oracle)

After the command execution finishes viewing the service-side character set again, it has been modified to UTF-8. Client Character Set modification 1, confirming client character set Windows command line runEcho%nls_lang%, or run the SQL statement:

1 SELECT *  from V$nls_parameters;

2. Modifying the client Character set

1 Set Nls_lang=simplified Chinese_china. Zhs16gbk

Reference article:http://blog.csdn.net/nsj820/article/details/6571105/http://jelly.iteye.com/blog/654300

Oracle 11g Character Set modification