可以由子集向超集改,象下面 US7ASCII -》WE8ISO8859P1 Yes US7ASCII -》ZHS16GBK Yes US7ASCII -》UTF8 Yes 具体步骤为: SQL> STARTUP MOUNT; SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE CHARACTER SET <new_character_set_name>; SQL> SHUTDOWN IMMEDIATE; -- or NORMAL SQL> STARTUP;
US7ASCII -》WE8ISO8859P1 Yes
US7ASCII -》ZHS16GBK Yes
US7ASCII -》UTF8 Yes
具体步骤为:
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET <new_character_set_name>;
SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
SQL> STARTUP;
或者到视图V$parameters里修改
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE 下的NLS_LANG字符串值修改为AMERICAN_AMERICA.us7ascii。
改如字段czbj(char 1)老是出现怪字符如"□",是跟他有关!