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)
2 Comments. Leave new
thanks. : ) pinaldave
but, google’s korean translation is horrible.
especially on technical article.
I’m sure that no one can understand. : (
Thanks a lot you regarding your ultimate assist