SQL Server备份排序规则问题
我获得了 SQL Server 2005 备份，其排序规则设置为：SQL_Latin1_General_CP1_CI_AI
当我选择任何数据时，数据似乎以不同的排序规则保存，例如：
用户：“Micha³” - 应该是“Michał”等
我尝试将表和数据库转换为波兰排序规则之一，也尝试使用排序规则选择，但它看起来仍然相同。
有没有人遇到过类似的问题并且知道到底发生了什么？
I was given SQL Server 2005 backup with collation set to : SQL_Latin1_General_CP1_CI_AI
When I select any data it looks like the data is saved in different collation , for example :
user : "Micha³" - which should be "Michał" and so on
I've tried converting tables and database to one of Polish collation, also tried select with collate but it still looks the same.
Have anyone had similar issue and knows what actually is going on ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
排序规则（排序顺序）意味着字符编码（将字符映射到字节） - 您是否尝试使用 Unicode（utf-8、utf-16）？在紧要关头，Latin-2（又名 ISO-8859-2，中欧单字节字符集）可能就是您正在寻找的。
换句话说，Latin-1 是西欧语言的单字节字符编码，但它不能存储中欧（或其他）语言的字符。
另请参阅有关字符集、排序规则和其他令人头疼的问题的详细说明。
Collation (sorting order) implies character encoding (mapping characters to bytes) - did you try using Unicode (utf-8, utf-16)? In a pinch, Latin-2 (a.k.a. ISO-8859-2, Central European single-byte charset) may be what you're looking for.
In other words, Latin-1 is a single-byte character encoding for Western-European languages, but it can't store characters from Central-European (or other) languages.
See also this for a longer explanation of charsets, collations, and other headaches.
你说“当我选择......”。查询结果显示在哪里？
You say "when I select ...". Where are the query results being displayed?
长话短说，排序规则与这个问题没有太大关系，保存数据的另一个应用程序使用一些混合编码来做到这一点，我发现他们自己无法正确显示数据。
To make long story short, the collation didn't have much to do with this issue, the other application that saved the data did that using some mixed-up encoding and I found out that they weren't able to display the data properly themselves.