SQL Server fn_helpcollations() to List Collations
SQL developers can use sql fn_helpcollations() function to return list of all collations which are supported by Microsoft SQL Server 2005 database instance.
If sql developers run the below fn_helpcollations() sql statement, they will get the list of all collations supported by SQL Server.
select * from fn_helpcollations()
The first column "Name" is the standard collation name and the second column is a description of the collation.
You can run the below sql statement to get the list of all collation which support Turkish.
SELECT
name, description
FROM fn_helpcollations()
WHERE
name like '%Turkish%'
In SQL Server 2000 ::fn_helpcollations() function is the equivalent function of fn_helpcollations() for SQL Server 2005
SELECT
name, description
FROM ::fn_helpcollations()
WHERE
name like '%Turkish%'