EAPTECH001100:数据访问异常：ORA-12704: 字符集不匹配

查看oracle表中列的数据类型

 

select   *   from   cols     
WHERE   TABLE_name=upper('table_name');

union oracle报错，比较字符集转换

cast(U . ACCOUNT as NVARCHAR2(40)) 字符集转换

 

sqlserver 

------查询一个表的所有列名，数据类型

select column_name,data_type from information_schema.columns 
where table_name = 'Sys_User'