oracle字符编码修改

1. 查看原编码

select * from nls_database_parameters where parameter =\'NLS_CHARACTERSET\';

1. 修改为AL32UTF8

$sqlplus /nologsql>conn /as sysdba;sql>shutdown immediate;mount数据库sql>startup mount;设置sessionSQL>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 AL32UTF8;关闭，重新启动SQL>shutdown immediate;SQL> startup

转载于:Oracle/2345654