本地字符集与数据库字符集不一致时报错,
解决:
1.修改本地字符集添加环境变量
修改为GBK
key:NLS_LANG
value:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改为UTF-8
key:NLS_LANG
value:AMERICAN_AMERICA.AL32UTF8
2.修改数据库的字符集
查看数据库字符集命令
select * from nls_database_parameters where parameter in ('NLS_LANGUAGE', 'NLS_TERRITORY','NLS_CHARACTERSET');
修改为GBK
?
修改为UTF-8
sqlplus "/ as sysdba"
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN
SQL> ALTER DATABASE
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP