ORA-12712: new character set must be a superset of old character set
来源:互联网 发布:美国人饮食 知乎 编辑:程序博客网 时间:2024/06/18 10:39
搭建了一台oracle服务端,在建库的时候字符集设置成了AL32UTF8字符集,导致与所有客户端的字符集不一致。
于是我想将字符集修改为ZHS16GBK。
首先查看服务端字符集
select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET'
NLS_CHARACTERSET ZHS16GBK
然后用sys用户进行修改
#sqlplus "/as sysdba"
>shutdown immediate;
>startup mount;
>ALTER SESSION SET SQL_TRACE=TRUE;
>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 ZHS16GBK;
ORA-12712: new character set must be a superset of old character set
RROR at line 1:
结果报错,提示新字符集必须是老字符集的超集。
于是强制转换
>ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
>shutdown immediate;
>STARTUP;
问题解决。
不过这样很可能让你的数据库中原有的中文显示乱码,所以还请慎重。在改变字符集时最好新的字符集是老字符集的超集。
INTERNAL_USE是没有写在文档中的参数,用于强制完成字符集转化
alter database character set internal_use &charset;
alter database national character set internal_use &ncharset;
- ORA-12712: new character set must be a superset of old character set
- 数据库字符集修改时报错ORA-12712: new character set must be a superset of old character set
- mysql:Collations Must Be for the Right Character Set
- ORA-12704:character set mismatch
- ORA-12704:character set mismatch
- Character Set
- Character set 'utf8mb4' is not a compiled character set
- day of year must be three character
- ORA-01453: SET TRANSACTION must be first statement of transaction
- ORA-01453: SET TRANSACTION must be first statement of transaction
- Multi-Byte Character Set & Unicode Character Set
- VS2013error MSB8031: Building an MFC project for a non-Unicode character set is deprecated. You must
- oracle character set
- Oracle Character set字符集
- oracle supported character set
- mysqldump --default-character-set
- 强行更换CHARACTER SET
- Unknown character set: 'utf8mb4'
- Lucene 4.0 的重大升级内容一览
- C/C++指针之三
- Redis多客户端连接问题总结
- 清理QT
- android上的i-jetty (1)环境搭建
- ORA-12712: new character set must be a superset of old character set
- 通过TEB/PEB枚举当前进程空间中用户模块列表
- html-中文字体在CSS中的显示(Unicode编码)
- linux 拷贝文件(本机内和机器之间)
- MySQL递归查询——数据平坦化新思维
- socket问题集合(待完善)
- android上的i-jetty (2)用Servlet显示Android设备的app列表
- Linux(CentOS 6.2)系统上安装Mplayer播放器
- 中断