oracle编码转换：AL32UTF8->ZHS16GBK

最新推荐文章于 2024-07-25 11:08:25 发布

xb12369

最新推荐文章于 2024-07-25 11:08:25 发布

阅读量8.5k

点赞数 1

分类专栏： Orcale 文章标签： oracle编码 ZHS16GBK AMERICAN_AMERICA.ZHS

本文链接：https://blog.csdn.net/xb12369/article/details/26345801

版权

Orcale 专栏收录该内容

44 篇文章 0 订阅

订阅专栏

首先查询数据库编码：

select userenv('language') from dual;

得到：

【更改编码】

--修改Oracle数据库字符集为utf-8:

SQL>conn / as sysdba;

SQL>shutdown immediate;

SQL>startup mount;

SQL>alter system enable restricted session;

SQL>alter system set job_queue_processes=0;

SQL>alter system set aq_tm_processes=0;

SQL>alter database open;

SQL>alter database character set internal_use utf8; --zhs16gbk

 

SQL>shutdown immediate;

SQL>startup;

再次执行：

-- 下面直接复制：

--修改Oracle数据库字符集为utf-8:

conn / as sysdba;

shutdown immediate;

startup mount;

alter system enable restricted session;

alter system set job_queue_processes=0;

alter system set aq_tm_processes=0;

alter database open;

alter database character set internal_use utf8; --zhs16gbk

 

shutdown immediate;

startup;