Oracle 生僻字乱码解决方案
“”(此+夕)【suǒ】字乱码,无法正常显示(变成问号);
生僻字“”(此+夕)(suo)在ZHS16GBK字符集下默认无法正常显示;
测试将生僻字类型由varchar2改成nvarchar2,同时使用utl_raw.cast_to_nvarchar2函数可以在数据库里正常显示;
select * from t1;
数据库字符集如下:
select * from nls_database_parameters;
T1表结构如下:
A字段为VARCHAR2类型
http://tool.chinaz.com/tools/unicode.aspx
---将生僻字生成对应的unicode编码
select utl_raw.cast_to_varchar2('3C54') from dual;
select utl_raw.cast_to_nvarchar2('3C54') from dual;
---测试varchar2类型无法正常存储生僻字””
truncate table t1;
alter table t1 modify (a nvarchar2(100));
insert into t1 values('?',1);
select * from t1;
update t1
set a =
(select utl_raw.cast_to_nvarchar2('3C54') from dual)
where b = 1;
select * from t1;
---测试nvarchar2类型可以正常存储生僻字”‘
truncate table t1;
alter table t1 modify (a nvarchar2(100));
insert into t1 values('?',1);
select * from t1;
update t1
set a =
(select utl_raw.cast_to_nvarchar2('3C54') from dual)
where b = 1;
select * from t1;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29785807/viewspace-2152540/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29785807/viewspace-2152540/