QUESTION: SQL SERVER: Collation

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hello All

Is there anyone on here who knows a bit about MS SQL Server and can explain in a very basic way so that even a moron like me can understand the following.....


What is Collation, I hear it's to do with the way data is sorted within a database, but other than that, I haven't got a clue.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

See here:

SQL Server Collation Fundamentals

 

Its the sort order for text data in the database, types like CHAR, VARCHAR and NVARCHAR