One of the databases you will be using on your new SQL Server holds data in several different languages, including U.S. English, German, and Italian. When your users search that data, they may be looking for information in any of the available languages. You want to be able to sort through data as quickly as possible, and you are not concerned with sensitivity. Choose the best sort order.

One of the databases you will be using on your new SQL Server holds data in several different languages, including U.S. English, German, and Italian. When your users search that data, they may be looking for information in any of the available languages. You want to be able to sort through data as quickly as possible, and you are not concerned with sensitivity. Choose the best sort order.


Answer – Binary

(Because your users might be looking for data in any language, you do not need the language-specific capability provided by binary code point. With both binary sort orders, case sensitivity is mandatory and cannot be shut off.)