Kodyaz Development Resources

fn_helpcollations()

You can use the fn_helpcollations() function to return the list of all collations that are supported by Microsoft SQL Server 2005
If you run the below sql statement you will get the list.

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%'