Which collation should you select?

You plan to add a new column named SmallKey to the Sales.Product table that will be used in a
unique constraint. You are required to ensure that the following information is applied when adding
the
new column:
‘a1’ and ‘A1’ are treated as different values
‘a’ and ‘A’ sort before ‘b’ and ‘B’ in an ORDER BY clause
You need to select the collation that meets the requirements for the new column. Which collation
should you select?

You plan to add a new column named SmallKey to the Sales.Product table that will be used in a
unique constraint. You are required to ensure that the following information is applied when adding
the
new column:
‘a1’ and ‘A1’ are treated as different values
‘a’ and ‘A’ sort before ‘b’ and ‘B’ in an ORDER BY clause
You need to select the collation that meets the requirements for the new column. Which collation
should you select?

A.
Latin1_General_BIN

B.
SQL_Latin1_General_CP1_CI_AI

C.
SQL_Latin1_General_CP1_CI_AS

D.
SQL_Latin1_General_CP1_CS_AS



Leave a Reply 0

Your email address will not be published. Required fields are marked *