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 *