When installing SQL Server, you meant to use the default SQL Collation setting (the Dictionary Order, Case-Insensitive, for Use with 1252 Character Set option); instead, you chose the case-sensitive version by accident. What should you do to switch to the correct character set?

When installing SQL Server, you meant to use the default SQL Collation setting (the Dictionary Order, Case-Insensitive, for Use with 1252 Character Set option); instead, you chose the case-sensitive version by accident. What should you do to switch to the correct character set?

When installing SQL Server, you meant to use the default SQL Collation setting (the Dictionary Order, Case-Insensitive, for Use with 1252 Character Set option); instead, you chose the case-sensitive version by accident. What should you do to switch to the correct character set?


Answer – Change the character set using SQL Server Configuration Manager

(Because your users are primarily looking for data in their own language, it is best to use the language-specific capability provided by binary code point. With both binary sort orders, case sensitivity is mandatory and cannot be shut off.)