SQL SERVER – 2005 Collation Explanation and Translation

Just a day before one of our SQL SERVER 2005 needed Case-Sensitive Binary Collation. When we install SQL SERVER 2005 it gives options to select one of the many collation. I says in words like ‘Dictionary order, case-insensitive, uppercase preference’. I was confused for little while as I am used to read collation like ‘SQL_Latin1_General_Pref_Cp1_CI_AS_KI_WI’. I did some research and find following link which explains many of the SQL SERVER 2005 collation.

Complete documentation MSDN – SQL SERVER Collation

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

Quest

SQL Collation
Previous Post
SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
Next Post
SQL SERVER – Six Properties of Relational Tables

Related Posts

25 Comments. Leave new

  • Raphy Poulose
    April 26, 2012 9:33 am

    Declare the parameter as nvarchar, and while inserting add ‘N’ as prefix.

    Reply

Leave a Reply