oracle 编码修改




SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>  startup mount;
ORACLE instance started.

Total System Global Area  849530880 bytes
Fixed Size                  1339824 bytes
Variable Size             499125840 bytes
Database Buffers          343932928 bytes
Redo Buffers                5132288 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 ;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.



select userenv('language') from dual ---查看编码


oraacle clinet  编码设置

打开注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1
将NLS_LANG 修改为
select userenv('language') from dual  查询的值