fn_helpcollations (Transact-SQL)

Returns a list of all the collations supported by SQL Server 2008.

Note

Deprecated collations that are no longer supported or installed in SQL Server 2008 cannot be queried with fn_helpcollations.

Syntax

fn_helpcollations ()

fn_helpcollations returns the following information.

Column name	Data type	Description
Name	sysname	Standard collation name
Description	nvarchar(1000)	Description of the collation

The following example returns all collation names starting with the letter L and that are binary sort collations.

USE AdventureWorks2008R2;
SELECT Name, Description FROM fn_helpcollations()
WHERE Name like 'L%' AND Description LIKE '% binary sort';

Here is the result set.

Name Description

------------------- ------------------------------------

Lao_100_BIN Lao-100, binary sort

Latin1_General_BIN Latin1-General, binary sort

Latin1_General_100_BIN Latin1-General-100, binary sort

Latvian_BIN Latvian, binary sort

Latvian_100_BIN Latvian-100, binary sort

Lithuanian_BIN Lithuanian, binary sort

Lithuanian_100_BIN Lithuanian-100, binary sort

(7 row(s) affected)