数据库编码修改 (服务器端)
1.先查看数据库当前编码:
select * from nls_database_parameters where parameter='NLS_CHARACTERSET'
此时会显示当前数据库的字符集,如果是UTF-8编码则会显示AL32UTF8
简体中文则显示ZHS16GBK
2.以管理员身份登陆
conn sys/xfht @xfht_db
3.关闭数据库
shutdown immediate;
4.设置SESSION
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
5.启动数据库
alter database open;
6.修改字符集
Alter database character set Internal_use_al32utf8;
1.先查看数据库当前编码:
select * from nls_database_parameters where parameter='NLS_CHARACTERSET'
此时会显示当前数据库的字符集,如果是UTF-8编码则会显示AL32UTF8
简体中文则显示ZHS16GBK
2.以管理员身份登陆
conn sys/xfht @xfht_db
3.关闭数据库
shutdown immediate;
4.设置SESSION
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
5.启动数据库
alter database open;
6.修改字符集
Alter database character set Internal_use_al32utf8;