ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK;
oracle修改字符编码
打开命令窗口
sqlplus shybt/shybt@localhost:1521/orcl
-
查看当前字符编码
- select userenv('language') from dual;
执行命令
- shutdown immediate;
- startup mount
- ALTER SYSTEM ENABLE RESTRICTED SESSION;
- ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
- ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
- ALTER SYSTEM SET AQ_TM_PROCESSES=0;
- alter database open;
- ALTER DATABASE character set INTERNAL_USE AL32UTF8;
- shutdown immediate
- startup
执行成功