Returns a list of all the collations supported by SQL Server 2008.
.gif)
Transact-SQL Syntax Conventions
.gif) Note: |
|---|
|
Deprecated collations that are no longer supported or installed in SQL Server 2008 cannot be queried with 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)
Reference
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
Help and Information
Getting SQL Server 2008 Assistance