--区分大小写
select * from V_IEMS_EMS3_ORG_EXG
where COP_G_NO COLLATE CHINESE_PRC_Ci_AS='cp002' AND EMS_NO='H0001'
--不区分大小写
select * from V_IEMS_EMS3_ORG_EXG
where COP_G_NO COLLATE CHINESE_PRC_CS_AS='cp002' AND EMS_NO='H0001'
COLLATE CHINESE_PRC_Ci_AS
COLLATE CHINESE_PRC_CS_AS