oracle修改字符集

《oracle修改字符集》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、oracle修改字符集2012-05-2808:47:56    我来说两句 收藏  我要投稿  [字体：小大]oracle修改字符集 查看oracle服务端编码：select*fromsys.nls_database_parameters;查看client编码：select*fromsys.nls_session_parameters; 修改客户端编码：翻开运转器进入注册表编辑运转--》regedit找到HKEY_LOCAL_MACHINE/ SOFTWARE/ www.2cto.com  ORACLE/KEY_OraDb10g_home1 的变量NLS_LANG的值SIMP

2、LIFIEDCHINESE_CHINA.ZHS16GBK改动成以下的值SIMPLIFIEDCHINESE_CHINA.AL32UTF8(效劳端编码) 服务端：1.在你的listener配置文件中增加实例信息SID_LIST_LISTENER=  (SID_LIST=   (SID_DESC=     (SID_NAME=PLSExtProc)     (ORACLE_HOME=F:oracleproduct10.1.0Db_1)     (PROGRAM=extproc)    )   (SID_DESC=    (SID_NAME=orcl)    (ORACLE_H

3、OME=F:oracleproduct10.1.0Db_1)   )  ) 2.修改oracle字符集SQL>startupmount;SQL>altersystemenablerestrictedsession;SQL>altersystemsetjob_queue_processes=0;SQL>alterdatabaseopen; www.2cto.com SQL>alterdatabasecharactersetinternal_useUTF8;SQL>shutdownimmediate;SQL>startup oracle查看字符集selectuserenv(

4、'language')fromdual;   Oracle10G,xe修改可以采用下面的方法 connectsystemassysdba;shutdownimmediate;startupmount;altersystemenablerestrictedsession; altersystemsetJOB_QUEUE_PROCESSES=0; altersystemsetAQ_TM_PROCESSES=0; alterdatabaseopen; alterdatabasecharactersetinternal_useZHS16GBK; shutdownimmediate;st

5、artup;    老版本可以参考 STARTUPMOUNT; ALTERSYSTEMENABLERESTRICTEDSESSION; ALTERSYSTEMSETJOB_QUEUE_PROCESSES=0; ALTERSYSTEMSETAQ_TM_PROCESSES=0; ALTERDATABASEOPEN; ALTERDATABASECHARACTERSETUTF8; ALTERDATABASEnationalCHARACTERSETUTF8; SHUTDOWNIMMEDIATE; STARTUP; www.2cto.com Databasecharacterset(UTF

6、8)andClientcharacterset(ZHS16GBK)aredifferent.Charactersetconversionmaycauseunexpectedresults. Note:youcansettheclientcharactersetthroughtheNLS_LANGenvironmentvariableortheNLS_LANGregistrykeyinHKEY_LOCAL_MACHINESOFTWAREORACLEKEY_OraDb11g_home1. 1)C:DocumentsandSettingsAdministrator>setN

7、LS_LANG=american_america.AL32UTF82)C:DocumentsandSettingsAdministrator>setNLS_LANG=SIMPLIFIEDCHINESE_CHINA.ZHS16GBKSIMPLIFIEDCHINESE_CHINA.ZHS16GBK 注册表 HKEY_LOCAL_MACHINE->software->oracle-》key_oradb11g_home1左侧的NLS_Lang SIMPLIFIEDCHINESE_CHINA.ZH