In my previous post, we have seen how to identify the collation settings in the server. The output which we got is not much clear to the normal users. That's why, Microsoft have introduced a built in function to identify the collation which can be understood by normal users.
The function name is
sys.fn_helpcollations() In my previous post, I got my collation setting for my server as, 'Latin1_General_CI_AI'. Below is the query to get the detailed description of the collation.
SELECT description FROM sys.fn_helpcollations() WHERE name = 'Latin1_General_CI_AI' The output is,
Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive Kanatype - It's Japanese support data
Width - Width of the data is not considered.
Try your query like below to get the collation settings and their detailed description.
SELECT description FROM sys.fn_helpcollations() WHERE name = 'Latin1_General_CI_AI' Cheers,
Venkatesan Prabu .J
Head -
http://www.kaashivinfotech.com/ http://venkattechnicalblog.blogspot.com/