首页 > 数据库 > Oracle > 正文

Oracle修改默认字符编码

2019-11-02 14:48:15
字体:
来源:转载
供稿:网友

   --查看Oracle数据库字符集:

  Sql代码

  select userenv('language') from dual;

  查询结果:

  SIMPLIFIED CHINESE_CHINA.AL32UTF8

  --修改oracle数据库字符集:(在SQL Plus中)

  Sql代码

  sql> conn / as sysdba;

  sql> shutdown immediate;

  database closed.

  database dismo

自然探索发现[www.9-39.com/html/explore/]
unted.

  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 AL32UTF8;

  sql> shutdown immediate;

  sql> startup;

  修改oracle用户的NLS_LANG

  编辑/home/oracle/.bash_profile

  Bash代码

  export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表