ORA-12704: 字符集不匹配

ORA-12704: 字符集不匹配,union 后面加了“TO_CHAR()”或者 CAST('11111' AS nvarchar2(50))，基本就搞定了。

     TO_CHAR(CAST('11111' AS nvarchar2(50))) AS "货品编号" ,

SELECT B.MANUFACTURENO , 
       B.C_SHORT_DE , 
       C.COLOR_NAME , 
       D.SIZENAME , 
       SUM(a.QTY_UNIT) AS QTY, 
       ( 
           CASE 
               WHEN B.RETAILPRICE IS NULL 
               THEN NVL (B.RETAILPRICE, 0) 
               WHEN B.RETAILPRICE = 0 
               THEN NVL (B.RETAILPRICE, 0) 
               ELSE B.RETAILPRICE 
           END 
       ) AS RETAILPRICE , 
       SH.SHOP_CNAME , 
       C.COLORSCHEME AS "配色", 
       A.ITEM_CODE AS "货品编号", 
       TRIM (A.ITEM_CODE) || TRIM (A.COLOR_CODE) ||TRIM (D.SIZECODE) AS SKU, 
       SH.SHOP_CODE, 
       PP.PROV_CNAME, 
       CI.CITY_CNAME, 
       SH.ADDRESS,
       B.itembasis 
  FROM AAAA.LOT A 

    UNION  

SELECT CAST('test' AS nvarchar2(50)) AS MANUFACTURENO ,
       CAST('test' AS nvarchar2(50)) AS C_SHORT_DE ,
       CAST('test' AS nvarchar2(50)) AS COLOR_NAME ,
       CAST('test' AS nvarchar2(50)) AS SIZENAME,
       1 AS QTY ,
       1 RETAILPRICE ,
       CAST('北京店' AS nvarchar2(50)) AS SHOP_CNAME, 
       CAST('11111' AS nvarchar2(50)) AS "配色",
       TO_CHAR(CAST('11111' AS nvarchar2(50))) AS "货品编号" ,
       TO_CHAR(CAST('11111111111111' AS nvarchar2(50))) AS SKU ,
       TO_CHAR(CAST('BJ002' AS nvarchar2(50))) AS SHOP_CODE ,
       CAST('北京市' AS nvarchar2(50)) AS PROV_CNAME ,
       CAST('北京' AS nvarchar2(50)) AS CITY_CNAME , 
       CAST('北京市add' AS nvarchar2(50)) AS ADDRESS,
       CAST('100%羊绒' AS nvarchar2(50)) AS itembasis