开发进行时...

crazy coder

Avatar

ORACLE 字符集

[Q]
  怎么样查看数据库字符集

[A]
  数据库服务器字符集select * from nls_database_parameters,其来源于props$
  客户端字符集环境select * from nls_instance_parameters,其来源于v$parameter
  会话字符集环境 select * from nls_session_parameters,其来源于v$nls_parameters

[Q]
  怎么样修改字符集

[A]
  Startup nomount;
  Alter database mount exclusive;
  Alter system enable restricted session;
  Alter system set job_queue_process=0;
  Alter database open;
  Alter database character set zhs16gbk;

评论已关闭