INTERVIEW QUESTIONS DATABASE MS SQL SERVER DETAILS

Question: What Is a Collation in MS SQL Server?

Answer: A collation is a set of rules defining a character set and its sorting rules. SQL Server support a large number of built-in collations. For example:

* Albanian_CI_AI_KS_WS - Albanian, case-insensitive (CI), accent-insensitive (AI), kanatype-sensitive (KS), width-sensitive (WS).
* Arabic_CI_AS_KS_WS - Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive.
* French_CI_AI - French, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive.
* Korean_Wansung_BIN - Korean-Wansung, binary sort.
* SQL_Latin1_General_CP1250_CI_AS - Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive.

If you want to get a list of all collations support on the SQL Server, run this statement:

SELECT * FROM fn_helpcollations()
GO

A collation is a set of rules defining a character set and its sorting rules. SQL Server support a large number of built-in collations. For example:

* Albanian_CI_AI_KS_WS - Albanian, case-insensitive (CI), accent-insensitive (AI), kanatype-sensitive (KS), width-sensitive (WS).
* Arabic_CI_AS_KS_WS - Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive.
* French_CI_AI - French, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive.
* Korean_Wansung_BIN - Korean-Wansung, binary sort.
* SQL_Latin1_General_CP1250_CI_AS - Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive.

If you want to get a list of all collations support on the SQL Server, run this statement:

SELECT * FROM fn_helpcollations()
GO Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question