admin管理员组

文章数量:1391943

In the ancient and sprawling tangle of databases at my workplace, columns that are used for case-insensitive search sometimes have their collation set to SQL_Polish_CP1250_CI_AS, and sometimes to Polish_CI_AS. Sometimes those match the database-wide collation of SQL_Polish_CP1250_CS_AS or Polish_CS_AS, sometimes not.

I know that both of these collations handle Polish fine (since different Poles recommend each as the case insensitive collation), that Microsoft's own documentation lists Polish_CI_AS as the default collation for Polish, and I should probably pick SQL_Polish_CP1250_CI_AS if the database-wide collation is SQL_Polish_CP1250_CS_AS...

...but I have no idea why should I pick one over the other in a fresh environment.

So: what's the difference between SQL_Polish_CP1250_CI_AS and Polish_CI_AS? Is there any practical difference for choosing one over the other? Are there any legacy-system-related considerations at play here?

本文标签： sql serverWhen should you choose SQLPolishCP1250CIAS versus PolishCIASStack Overflow

版权声明：本文标题：sql server - When should you choose SQL_Polish_CP1250_CI_AS versus Polish_CI_AS? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744686829a2619753.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。