Language/Collation (Analysis Server Properties Dialog Box) (SSAS)
Use the Language/Collation page of the Analysis Server Properties dialog box in SQL Server Management Studio to set the default language and default collation properties for an Analysis Services instance.
Options
Term
Definition
Windows Collation
Select the Microsoft Windows collation to use as the default collation for the Analysis Services instance.
Binary
Select this collation to sort and compare data based on the bit patterns defined for each character. Binary sort order is case-sensitive, that is, lowercase precedes uppercase, and accent-sensitive. This is the fastest sorting order.
If this collation is not selected, Analysis Services follows sorting and comparison rules as defined in dictionaries for the associated language or alphabet.
In the BIN1 collation and other standard Windows collations, the collations compare all supplementary characters as equal to all other supplementary characters. Therefore, neither BIN1, nor the default Japanese and Korean collations, can handle supplementary characters.
.gif "ms188527.note(en-US,SQL.90).gif")
Note:
If this collation is selected, the Case-Sensitive, Accent-Sensitive, Kana-Sensitive, and Width-Sensitive options are disabled.
Binary 2
Select this collation to sort and compare data based on the bit patterns defined for each character. Binary sort order is case-sensitive, that is, lowercase precedes uppercase, and accent-sensitive. This is the fastest sorting order.
The BIN2 collation, along with the new _90 collations, is capable of comparing supplementary characters. For example, BIN2, the Japanese_90, and the Korean_90 collations compare and sort supplementary characters correctly.
If this collation is not selected, Analysis Services follows sorting and comparison rules as defined in dictionaries for the associated language or alphabet.
Note:
If this collation is selected, the Case-Sensitive, Accent-Sensitive, Kana-Sensitive, and Width-Sensitive options are disabled.
Case-Sensitive
Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between uppercase and lowercase letters.
If this option is not selected, Analysis Services considers the uppercase and lowercase versions of letters to be equal. Analysis Services does not define whether lowercase letters sort lower or higher in relation to uppercase letters when Case-sensitive is not selected.
Accent-Sensitive
Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between accented and unaccented characters. For example, 'a' is not equal to 'á'.
If this option is not selected, Analysis Services considers the accented and unaccented versions of letters to be equal.
Kana-Sensitive
Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between the two types of Japanese kana characters: Hiragana and Katakana.
If this option is not selected, Analysis Services considers Hiragana and Katakana characters to be equal.
Width-Sensitive
Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between a single-byte character (half-width) and the same character when represented as a double-byte character (full-width).
If this option is not selected, Analysis Services considers the single-byte and double-byte representation of the same character to be equal.
Select the language for the server
Select the Windows language and culture to use as the default language for the Analysis Services instance.
See Also
Reference
Analysis Server Properties Dialog Box (SSAS)
General (Analysis Server Properties Dialog Box) (SSAS)
Security (Analysis Server Properties Dialog Box) (SSAS)