oracle修改字符编码

时间:2021-06-22 17:36:24

ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 

ALTER DATABASE CHARACTER SET ZHS16GBK; 

oracle修改字符编码    1

1    打开命令窗口    2

2    查看当前字符编码    3

3    执行命令    4

oracle修改字符编码

  1. 打开命令窗口

oracle修改字符编码oracle修改字符编码sqlplus shybt/shybt@localhost:1521/orcl

oracle修改字符编码

  1. 查看当前字符编码

    1. select userenv('language') from dual;
  1. 执行命令

oracle修改字符编码

  1. shutdown immediate;

oracle修改字符编码

  1. startup mount
  2. ALTER SYSTEM ENABLE RESTRICTED SESSION;
  3. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
  1. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
  1. ALTER SYSTEM SET AQ_TM_PROCESSES=0;
  2. alter database open;

oracle修改字符编码

  1. ALTER DATABASE character set INTERNAL_USE AL32UTF8;
  2. shutdown immediate
  3. startup

oracle修改字符编码

执行成功