oracle报错——字符集不匹配

襟裳岬的风

于 2014-05-09 17:15:23 发布

阅读量2.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.csdn.net/healingangle/article/details/25410841

Oracle 专栏收录该内容

2 篇文章

订阅专栏

在执行查询下面语句时，出现了字符集不匹配的错误。

select 
  zsbh as 证书编号,
  zxri as 登记日期,
  '' as 需注销证书编号,
  '' as 需注销注销日期,
from cqk.dbo.zsb1
union
select 
  zsbh as 证书编号,
  zxri as 登记日期,
  '' as 需注销证书编号,
  '' as 需注销注销日期,
from cqk.dbo.zsb2

经过查资料，发现是字段类型为 NVARCHAR2() 常会发生的问题。

改为：

select 
  zsbh as 证书编号,
  zxri as 登记日期,
  N'' as 需注销证书编号,
  N'' as 需注销注销日期,
from cqk.dbo.zsb1
union
select 
  zsbh as 证书编号,
  zxri as 登记日期,
  N'' as 需注销证书编号,
  N'' as 需注销注销日期,
from cqk.dbo.zsb2

问题解决~