玖叶教程网

oracle--ora-12704字符集不匹配问题

select 1,cast('d' as nvarchar2(20)) dd
from dual
union all
select 2,'2'
from dual

报oracle--ora-12704字符集不匹配问题

------------------------------------------------------------------------------------------------

处理方法

nvarchar2和varchar2的问题，处理，在varchar2前加N，或把varchar2转为Nvarchar2

select 2,cast(id as nvarchar2(10)) dd
from aa
union all
select 2,N'2'
from dual

2023-3-18