Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

fn_helpcollations (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions


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

fn_helpcollations ()

fn_helpcollations returns the following information.

Column name

Data type




Standard collation name



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)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft