请问oracle中这个union的sql语句为什么包错！谢谢各位，帮忙看一下

[5iasp]

select mc,dm from jsods.dm01_dm_sxzm where dm!='010'
union all
select 'bbb' mc,'sxzm<>010' dm from dual
union all
select 'aaa' mc,'sxzm=010' dm from dual

其
目的就是为了在某个记录集中加上几条固定值的记录！谢谢各位，帮忙看一下

[chd2001]

包什么错
？

[5iasp]

包错代码：ora-12704:字符集不匹配

[沝林]

确认mc数据类型是字符类型的么

[5iasp]

DM NVARCHAR2(20) not null,
MC NVARCHAR2(100),

[zhao_e893]

字符集问题,参看下面
select z,x from ZZ
union all
select N'bbb' mc,N'sxzm<>010' dm from dual
union all
select N'aaa' mc,N'sxzm=010' dm from dual

[xiaoxiao1984]

sys@TASCII>select mc,dm from (select '1' as mc, '010' as dm from dual
2 union select '2' as mc, '0101' as dm from dual
3 ) where dm!='010'
4 union all
5 select 'bbb' mc,'sxzm<>010' dm from dual
6 union all
7 select 'aaa' mc,'sxzm=010' dm from dual
8 /

MC DM
--- ---------
2 0101
bbb sxzm<>010
aaa sxzm=010

确认jsods.dm01_dm_sxzm 的mc,dm两个字段查询出来的值都是字符