数据库oracle 11g 字符集we8mswin1252 不支持中文

服务器 linux

修改字符集为ZHS16GBK

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 523108352 bytes

Fixed Size 1337632 bytes

Variable Size 356517600 bytes

Database Buffers 159383552 bytes

Redo Buffers 5869568 bytes

Database mounted.

SQL> alter session set sql_trace=true;

Session altered.

SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter system set aq_tm_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set ZHS16GBK;

alter database character set ZHS16GBK

*

ERROR at line 1:

ORA-12712: new character set must be a superset of old character set

SQL> alter database character set internal_use ZHS16GBK;

Database altered.

红色部分的错误不影响

到此修改成功,支持中文

ITPub博客

oracle 字符集中文乱码问题