Hey Folks,

You would have seen in my previous posts, that how the Collation Settings is configured during the Installation of SQL Server. You can also refer to that article by the link;

So once the collation setting is decided is being set as the default for all the Server, Database, Column and Query level. It can also be configured by using the Query editor.

SQL Server’s collation order is vital to sorting data because it not determines the alphabet, but also the accents, case, and other alphabet properties. If the collation is case sensitive, then the uppercase letters are sorted before the lowercase letters.

The following function gives you the list of installed collation options:


The following query reports the current server collation:


The Collation setting for the Server Level can only be configured during the Installation of SQL Server 2008; otherwise the only option to change is to reinstall the SQL Server setup.

The Collation property for a Database or a Column can be set using the COLLATE keyword. The following code changes the ‘Test’ database collation so that it becomes case sensitive:

Now, to view the current database collation properrty, write the following command:


When you create a table, you can specify collations for each character-string column by using the COLLATE clause of the CREATE TABLE statement. If no collation is specified, the column is assigned the default collation of the database.

The collation of a column can be changed by using an ALTER TABLE statement similar to the following:

The Collation Property for Query can also be set but only with the combination of ORDER BY clause which will return a set of sorted rows:


Well this was all about the Configuration of Collation Settings.

Hope you like it.



Piyush Bajaj

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook