Question

oracle数据库编码怎么从GBK32转到UTF-8

打开数据库以后SQL下输入alter database character set internal_use utf-8提示 ORA-00933: SQL 命令未正确结束之前操作为<strong>SQL

Answer 1

直接通过alter 方法直接修改 character为 UTF-8即可。
　　sql> conn / as sysdba;
　　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 UTF-8;
　　sql> shutdown immediate;
　　sql> startup;

Answer 2

shutdown immediate;
startup mount;
alter session set sql_trace=true;
alter system enable restricted session;
alter database open;
alter database character set internal_use utf-8;
shutdown immediate;
startup;
select userenv('language') from dual;

按照这个步骤来

Answer 3

在注册表里改一下oracle的lang值就可以。