查看oracle数据库字符集: select userenv(’language’) from dual;
修改过程: SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 135337420 bytes Fixed Size 452044 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. 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 INTERNAL_USE UTF8 或者修改成zhs16gbk编码格式 SQL> alter database character set zhs16gbk
SQL> shutdown immediate //先关闭数据库,再开启使之字符集生效 Database closed. Database dismounted. ORACLE instance shut down.
SQL>startup