ID NAME C
--- ------------------------------ -
a01 鍖荤枟鍣ㄦ C
a03 瑗胯嵂 C
c04 鎬婚儴 A
d01 鐢茬骇鍖婚櫌 B
d02 涔欑骇鍖婚櫌 B
d03 涓欑骇鍖婚櫌 B
d04 鑽簵 B
d05 鍏朵粬 B
查询用户的时候出现乱码网上的方法试了不少希望大家帮帮忙!
...全文
32211打赏收藏
Oracle 10g 存储中文乱码问题?
ID NAME C --- ------------------------------ - a01 鍖荤枟鍣ㄦ C a03 瑗胯嵂 C c04 鎬婚儴 A d01 鐢茬骇鍖婚櫌 B d02 涔欑骇鍖婚櫌 B d03 涓欑骇鍖婚櫌 B d04 鑽簵 B d05 鍏朵粬 B 查询用户的时候出现乱码网上的方法试了不少希望大家帮帮忙!
sqlplus "/as sysdba"
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 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> set linesize 120;
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; # 使用INTERNAL_USE可以跳过超集的检查,ALTER DATABASE character set INTERNAL_USE
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.