定序對話方塊 (Visual Database Tools)Collation Dialog Box (Visual Database Tools)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

這個對話方塊讓您指定資料行的定序序列 (Collation Sequence)。This dialog box lets you specify a collation sequence for the column. 在將資料行的值與另一個資料行的值或常數值進行比較的任何作業中,會使用資料行的定序序列。A column's collation sequence is used in any operation that compares values of the column to another column or to constant values. 它也會影響某些字串函數的行為,例如 SUBSTRING 和 CHARINDEX。It also affects the behavior of some string functions, such as SUBSTRING and CHARINDEX. 如需資料行定序設定作用的完整清單,請參閱 SQL ServerSQL Server 文件。For a complete list of the effects of a column's collation setting, see the SQL ServerSQL Server documentation.

下列情況會出現這個對話方塊:This dialog box appears:

  • 在 [資料行屬性] 索引標籤的 [定序] 欄位中輸入無效的定序名稱。If you enter an invalid collation name in the Collation field on the Column Properties tab.

  • 在 [資料行屬性] 索引標籤的 [定序] 欄位中按一下,然後按一下欄位右側的省略符號按鈕 ( ... )。If you click in the Collation field on the Column Properties tab, and then click the ellipsis button (...) to the right of the field.

選項。Options

SQL 定序SQL Collation
從下拉式清單中選擇 SQL ServerSQL Server 所定義的定序序列。Choose among the collation sequences defined by SQL ServerSQL Server from the drop-down list.

Windows 定序Windows Collation
從下拉式清單中選擇 Windows 所定義的定序序列。Choose among the collation sequences defined by Windows from the drop-down list.

二進位編碼排序Binary Sort
使用字元值的二進位碼進行比較。Use the binary codes of character values for comparisons. 如果選取此選項,某些字母順序比較選項會無法使用。If you select this option, certain alphabetic comparison options become unavailable. 例如,區分字母大小寫的比較會無法使用,因為大寫字母和小寫字母有不同的二進位編碼方式。For example, case-insensitive comparisons become unavailable because uppercase letters and lowercase letters have different binary encodings. 只有在選取 [Windows 定序] 時適用。Applies only if you select Windows collation.

字典排序Dictionary Sort
使用字母順序比較選項。Use alphabetic comparison options. 只有在選取 [Windows 定序] 時適用。Applies only if you select Windows collation. The alphabetic comparisons options are:The alphabetic comparisons options are:

  • 區分大小寫 :若要比較作業將大寫和小寫字母視為不相同,請選取此選項。Case Sensitive Select this if you want comparisons to consider uppercase and lowercase letters to be unequal.

  • 區分腔調字 (Accent Sensitive):若要比較作業將腔調字母和非腔調字母視為不相同,請選取此選項。Accent Sensitive Select this if you want comparisons to consider accented and unaccented letters to be unequal. 如果選取此選項,比較作業也會將不同的腔調字母視為不相同。If you select this, comparisons will also consider differently accented letters to be unequal.

  • 區分假名 :若要比較作業將日文音節的片假名和平假名視為不相同,請選取此選項。Kana Sensitive Select this if you want comparisons to consider katakana and hiragana Japanese syllables to be unequal.

  • 全半形需相符 (Width Sensitive):若要比較作業將半形字元和全形字元視為不相同,請選取此選項。Width Sensitive Select this if you want comparisons to consider half-width and full-width characters to be unequal.

還原預設值按鈕Restore Default Button
對此資料行套用預設的資料庫定序序列。Apply the default collation sequence for the database to the column.

另請參閱See Also

在彙總查詢中使用資料行 (Visual Database Tools)Work with Columns in Aggregate Queries (Visual Database Tools)