SQL Server – Good Articles on Database Collation

I often get asked what is Database Collation in SQL Server and if there are some good articles related to Collation. Here are some really interesting articles on this subject.

SQL SERVER – Creating Database with Different Collation on Server
Can we create a database with different collations on the same SQL Server Instance? We thought, the collation of the server is fixed during the installation and all the database on the system have to follow the same default collation.

SQL SERVER – Cannot resolve collation conflict for equal to operation
If columns ItemsTable.Collation1Col and AccountsTable.Collation2Col have different collation, it will generate the error “Cannot resolve collation conflict for equal to operation“.

Solarwinds

SQL SERVER – Collate – Case Sensitive SQL Query Search

In this blog post we are going to learn about how to do Case Sensitive SQL Query Search.

SQL Server - Good Articles on Database Collation casesensitive

If Column1 of Table1 has following values ‘CaseSearch, case search, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records. If you think I have missed any good article on this subject. Please leave a comment and I will make sure to edit this blog post and add it. To make the query case sensitive and retrieve only one record (“casesearch”) from the above query, the collation of the query needs to be changed as mentioned in the blog.

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

Solarwinds
, , ,
Previous Post
SQLAuthority News – Learn New Things – Self Criticism
Next Post
SQL SERVER – 2005 – Transferring Ownership of a Schema to a User

Related Posts

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. : (

    Reply
  • Luther Coalter
    March 10, 2010 4:52 pm

    Thanks a lot you regarding your ultimate assist

    Reply

Leave a Reply

Menu