![sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange](https://i.stack.imgur.com/BCp53.jpg)
sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange
![sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow](https://i.stack.imgur.com/8zH4g.png)
sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow
![sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange](https://i.stack.imgur.com/egryu.jpg)