Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report