Export (0) Print
Expand All
Expand Minimize

fn_helpcollations (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

NoteNote

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

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 AdventureWorks;
SELECT Name, Description FROM fn_helpcollations()
WHERE name like 'L%' AND description LIKE '% binary sort';

Here is the result set.

Name                   Description
-------------------    ------------------------------------
Latin1_General_BIN     Latin1-General, binary sort
Latvian_BIN            Latvian, binary sort
Lithuanian_BIN         Lithuanian, binary sort
Lithuanian_Classic_BIN Lithuanian-Classic, binary sort

(4 row(s) affected)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft