怎么查看oracle数据库中的的编码格式

Question

如题所述

Answer 1

首先查看oracle数据库的编码:SQL>select*fromnls_database_parameterswhereparameter='NLS_CHARACTERSET';修改字符集编码(这会对数据库的数据有直接的影响,谨慎操作):SQL>conn/assysdbaSQL>shutdownimmediate;SQL>startupmount;SQL>ALTERSYSTEMENABLERESTRICTEDSESSION;SQL>ALTERSYSTEMSETJOB_QUEUE_PROCESSES=0;SQL>ALTERSYSTEMSETAQ_TM_PROCESSES=0;SQL>alterdatabaseopen;SQL>ALTERDATABASEcharactersetINTERNAL_USEZHS16GBK;SQL>shutdownimmediate;SQL>startup

Answer 2

SQL>selectuserenv('language')fromdual;USERENV('LANGUAGE')----------------------------------------------------SIMPLIFIEDCHINESE_CHINA.AL32UTF8