【Bug?】String type column values ​​between different environments cannot be compared with "="

[hiroyuki0415]

String type column values ​​between different environments cannot be compared with "="

SELECT *
FROM   [dev].dbo.systemuser AS s_dev
       INNER JOIN
       [prod].dbo.systemuser AS s_prd
       ON s_dev.fullname = s_prd.fullname;

When I run this SQL, I get the below error:

Cannot resolve collation conflict for equals operation: s_dev.fullname = s_prd.fullname

Thanks in advance for your support.

[MarkMpn]

Thanks, moved to issue #325