[Case] cannot resolve the collation conflict between & quot;xxx" and & quot;xxx"

Disclaimer: reproduced from https://www.cnblogs.com/panchunting/p/SQLServer_Issue_Collation.html

The conflict of sorting rules (collation) for SQL Server problems

"in the interface, the system defaults to the option of selecting the collation in the form of the following drop-down box). This method completely solves the problem and is recommended.

Fourth, write at the end

When you do a database migration later, you should first add the collation to check the existing database, and then when you install the database on the new server, you should make sure it is consistent with the collation of the original database. An extension: in fact, not only the collation, but also other conflicts or incompatibilities should be checked accordingly to solve the problem before upgrading or migrating, rather than leaving the problem on the new server, because once time is tight, it will be a disaster, especially the upgrade of formal libraries.