SQL Server – Good Articles on Database Collation

I often get asked what Database Collation is in SQL Server and whether there are any good resources to explore this topic. Collation in SQL Server defines how data is sorted and compared, including rules for character case and accent sensitivity. Below are some insightful articles on this subject that address various aspects of collation in SQL Server.

SQL SERVER – Creating Database with Different Collation on Server

Can you create a database with a different collation on the same SQL Server instance? Many assume that the collation is fixed during installation and that all databases on the server must follow the default collation. This article explores how to override the server’s default collation for individual databases.

SQL SERVER – Cannot Resolve Collation Conflict for Equal To Operation

When two columns from different tables (e.g., ItemsTable.Collation1Col and AccountsTable.Collation2Col) have different collations, SQL Server generates the error:
“Cannot resolve collation conflict for equal to operation.”
This post explains the reasons for such conflicts and how to resolve them effectively.

SQL SERVER – Collate – Case Sensitive SQL Query Search

This article dives into case-sensitive SQL query searches. For example, consider a column in a table with the following values: CaseSearch, case search, CASESEARCH, CaSeSeArCh. By default, a query will return all four records. If you want the query to retrieve only a specific value (e.g., casesearch), you need to modify the collation settings of the query. This post details how to achieve that.

Share Your Suggestions

If you think I’ve missed any valuable articles on this topic, please leave a comment. I will make sure to update this blog post with your suggestions. You can connect with me on Twitter.

Reference: Pinal Dave (https://blog.sqlauthority.com)