(注:修改数据库可能会造成原数据乱码或数据库崩溃,务必做好备份,且行且珍惜。)
一般修改字符集步骤:(原文链接:https://www.cnblogs.com/mrszhao-dream/p/7515304.html)
- select userenv('language') from dual; //查看系统字符集编码
- select * from nls_database_parameters where parameter in ('NLS_CHARCTERSET','NLS_NCHAR_CHARACTERSET');
- shutdown immediate
- startup
- alter session set sql_trace=true;
- alter system enable restricted session;
- show parameter job_queue_processes;
- alter system set job_queue_processes=0;
- alter system set aq_tm_processes=0;
- alter database character set INTERNAL_USE AL32UTF8;
- update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';
1. 如果编码一样,单独语言切换修修改配置文件
$ORACLE_HOME/dbs/dbs/spfileorcl.ora
我的文件位置:
2. 修改 *.nls_language 和 *.nls_territory 字段
3. 重启数据库
shutdown immediate
startup
4.检车是否修改成功 select userenv('language') from dual;