What is the purpose of Fn_helpcollations() ?

 Posted by Niladri.Biswas on 5/1/2013 | Category: Sql Server Interview questions | Views: 1356 | Points: 40
Answer:

To get a list of all sql server collations we can execute "Fn_helpcollations() " system function. This will return name and description of various collations.

e.g.
select * from fn_helpcollations()


Result(Partial)

name description
Albanian_BIN Albanian, binary sort
Albanian_BIN2 Albanian, binary code point comparison sort
Albanian_CI_AI Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Albanian_CI_AI_WS Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Albanian_CI_AI_KS Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Albanian_CI_AI_KS_WS Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response