In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t already). Here, I will show you how to change the server-level collation or the SQL Server instance-level collation of an existing SQL Server instance.Read More
When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and compared. You can store your data in a specific language, or you may want SQL Server to treat case-sensitive and case insensitive data separately. Microsoft has provided an SQL Server setting called Collation to control and address such requirements.Read More
You must have already heard the term “Collation” in SQL Server. Collation is a configuration that determines how character data sorting is done. This is an important setting that has a huge impact on how the SQL Server database engine behaves in dealing with character data. In this article, we aim to discuss collations in general and show a few examples of dealing with collations.