SQL Server Collation

What is Collation? Collation is a set of rules dictating how each group of characters within SQL Server is treated. A list of collations and their definitions can be found using the following query. SELECT name, description FROM sys.fn_helpcollations() WHERE COLLATIONPROPERTY(name, ‘CodePage’) = 0; There are two types of collations which will appear in the … Continue reading SQL Server Collation