Cannot resolve sort conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in equal action

Question

I am getting the sorting error shown below since I switched from a desktop computer to a laptop. Hundreds of stored procedures are stored in my database, so any solution, such as overriding some queries or fixing collation for a column, is impossible for me.

"Cannot resolve collision conflict between" SQL_Latin1_General_CP1_CI_AS "and" Latin1_General_CI_AI "in equal action"

My problem is not unique, and I searched for it quite a lot, but the available solutions allow me to redefine requests with some code that is impossible. Please suggest some solution that can avoid this thing.

I tried this to change the sorting of the database.

ALTER DATABASE testDB COLLATE French_CI_AI ; GO 

Thank.

Answer 1

Just use the following syntax to match on the fly when combining tables with different sorts. I integrate the system, so I have to do this.

 select * from [Product] p join [category] c on c.[Name] collate SQL_Latin1_General_CP1_CI_AS = p.[Name] collate SQL_Latin1_General_CP1_CI_AS 

Answer 2

 USE master; GO ALTER DATABASE PRATAP COLLATE Latin1_General_CI_AS_KS_WS ; GO --Verify the collation setting. SELECT name, collation_name FROM sys.databases WHERE name = N' PRATAP '; GO 

Answer 3

jUST ADD this line -> SQL_Latin1_General_CP1_CI_AS in your connections. This is it :) https://premkt.blogspot.my/2016/12/error-cannot-resolve-collation-conflict.html