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