SQLserver条件发现半角与全角他不分.处理的时候要修改原有的排序规则

select t2.*
 from TTS_QualityCheck_OP t1 with(nolock)                                
 inner join TTS_QualityCheck_Item t2 with(nolock) on t1.id=t2.ParentId                                
 where t1.CompanyId=2021101709464166163 and t1.id=2405211448302148387 and t2.CheckItem COLLATE Chinese_PRC_CS_AS_WS ='端子高度(+)'