ORA-12704:字符集不匹配 [英] ORA-12704: character set mismatch
本文介绍了ORA-12704:字符集不匹配的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我这样做时地狱
select COALESCE (CORP_ID, 0) from crmuser.accounts;
为Null的CORP_ID记录返回0,但是当我这样做时:
The CORP_ID records which are Null returns 0 but when I do:
select COALESCE (EMAIL, 'NO EMAIL') from crmuser.accounts
我收到一个错误:
ORA-12704: character set mismatch
NVARCHAR2(30)中的EMAIL字段.是我的数据类型,如果是,我该怎么做才能返回默认值?
The EMAIL field in NVARCHAR2(30). Is is My Datatype and if so What should I do to return default Values?
推荐答案
您应该这样做
select COALESCE (EMAIL, n'NO EMAIL') from crmuser.accounts
将该文字转换为NVARCHAR.
to convert the literal to NVARCHAR.
例如 http://sqlfiddle.com/#!4/73929/1 与 http://sqlfiddle.com/#!4/73929/2
这篇关于ORA-12704:字符集不匹配的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文