![Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.](http://lh6.ggpht.com/_9WdQG0JZ7go/S9l8oftrRtI/AAAAAAAADtM/0rslOo10nwI/image_thumb%5B8%5D.png?imgmax=800)
Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa9.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa8.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa7.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.](http://lh6.ggpht.com/_9WdQG0JZ7go/S9l8pDr0pmI/AAAAAAAADtU/sg43-Vxazd4/image_thumb%5B13%5D.png?imgmax=800)
Thoughts on Azure, OMS & SCOM: Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
![Erik Brandstadmoen on Twitter: "This is what collations in SQL server are for... DANISH_NORWEGIAN_CI_AS ftw ;) I *think* you can specify it in your SELECT statements as well, not just specify it Erik Brandstadmoen on Twitter: "This is what collations in SQL server are for... DANISH_NORWEGIAN_CI_AS ftw ;) I *think* you can specify it in your SELECT statements as well, not just specify it](https://pbs.twimg.com/media/Ee6PSUHWkAEvRvj.png)
Erik Brandstadmoen on Twitter: "This is what collations in SQL server are for... DANISH_NORWEGIAN_CI_AS ftw ;) I *think* you can specify it in your SELECT statements as well, not just specify it
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa1.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa14.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa18.png)
Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog
![Database Migration Assistant fails with error 'Cannot resolve the collation conflict' - Microsoft Q&A Database Migration Assistant fails with error 'Cannot resolve the collation conflict' - Microsoft Q&A](https://docs.microsoft.com/answers/storage/attachments/30289-20201006testassessment.jpg)
Database Migration Assistant fails with error 'Cannot resolve the collation conflict' - Microsoft Q&A
![Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog Collation Matters – Few things to note when thinking your Server's or database's collation and easy tool to test collations - Blog](https://www.qumio.com/Blog/Lists/Photos/051614_0952_CollationMa11.png)