查询语句 select aa.* from [dbo].[IPE_SeNamelist] aa left join [dbo].[TFS] ee
on charindex(aa.[EnglishName],ee.[SEName])>0
报错信息Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the charindex operation.aa.[EnglishName]中内容就是普通的中文名,如Paul Zhu
而ee.[SEName])应该会有一个 Paul Zhu (xxxx) 与之对应,现在我没明白为什么会出错,系统语言应该都是英语
on charindex(aa.[EnglishName],ee.[SEName])>0
报错信息Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the charindex operation.aa.[EnglishName]中内容就是普通的中文名,如Paul Zhu
而ee.[SEName])应该会有一个 Paul Zhu (xxxx) 与之对应,现在我没明白为什么会出错,系统语言应该都是英语
on charindex(aa.[EnglishName] COLLATE Chinese_PRC_CI_AS,ee.[SEName] COLLATE Chinese_PRC_CI_AS)>0
SELECT aa.*
FROM [dbo].[IPE_SeNamelist] aa
LEFT JOIN [dbo].[TFS] ee ON CHARINDEX(aa.[EnglishName] COLLATE SQL_Latin1_General_CP1_CI_AS,ee.[SEName]) > 0