Modifying character sets in oracle

Oracle modify character set view oracle server code: select * from sys. nls_database_parameters; check the client code: select * from sys. nls_session_parameters; modify the client encoding: open the runner and go to the Registry to edit and run -- regedit. Find the value of the variable NLS_LANG in HKEY_LOCAL_MACHINE/SOFTWARE/www.2cto.com ORACLE/KEY_OraDb10g_home1, Which is changed to the following value: 1. add the instance information SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) to your listener configuration file (ORACLE_HOME = F: \ oracle \ product \ 10.1.0 \ Db_1) (PROGRAM = extproc) (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME = F: \ oracle \ product \ 10.1.0 \ Db_1) 2. modify the oracle Character set SQL> startup mount; SQL> alter system enable restricted session; SQL> alter system set job_queue_processes = 0; SQL> alter database open; www.2cto.com SQL> alter database character set internal_use UTF8; SQL> shutdown immediate; SQL> startup oracle view character set select userenv ('language') from dual; Oracle10G, xe modification can use the following method to connect system as sysdba; 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 ZHS16GBK; shutdown immediate; startup; for earlier versions, see 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 UTF8; alter database national character set UTF8; shutdown immediate; STARTUP; www.2cto.com Database character set (UTF8) and Client character set (ZHS16GBK) are different. character set conversion may cause unexpected results. note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key inHKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ KEY_OraDb11g_home1. 1) C: \ Documents and Settings \ Administrator> set NLS_LANG = american_america.AL32UTF82) C: \ login ents and Settings \ Administrator> set NLS_LANG = SIMPLIFIED login Login registry HKEY_LOCAL_MACHINE-> software-> oracle-key_oradb11g_home1 NLS_Lang SIMPLIFIED author jianhuili