Modification of the Oracle database character set

This digest from: http://blog.csdn.net/nsj820/article/details/6571105
1, change the client character set: Run Regedit from the Windows Run menu, modify the registry startRun--Rededit <-|under Registry Editor-> HKEY_LOCAL_MACHINE, Software->oracle->key_xe->right WINDOW DOUBLE CLICK Nls_lang, change VALUE To "American_america. UTF8 "->okCLOSE REGISTRY method for setting the Oracle client character set correctly: The Oracle client character set settings need to be consistent with the server side, or garbled problems will occur. First connect to server, query server-side settings: Select*from V$nls_parameters; found: Nls_languagenls_territorynls_characterset environment variable Nls_lang is made up of these three parts Nls_lang=Language_territory.charset such as: Nls_lang=American_japan.ja16sjis2, change the server-side character set, and change it through the SQL Plus Command window of Oracle to SQL*PLUS, log on as DBA with Conn username as SYSDBA and execute the following command>shutdown immediate; (the database was stopped)>startup Mount; (Re-open the database to change the situation)>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 Utf8;or>ALTER DATABASE character set Internal_use UTF8;>shutdown immediate;>startup; (Re-open normal Oracle) Oracle Database Character Set modification complete! 

Modification of the Oracle database character set