sys.fn_helpcollations (Transact-SQL)sys.fn_helpcollations (Transact-SQL)

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

傳回所有支援之定序的清單。Returns a list of all supported collations.

主題連結圖示 Transact-SQL 語法慣例Topic link icon Transact-SQL Syntax Conventions

語法Syntax

fn_helpcollations ()  

傳回的資料表Tables Returned

fn_helpcollations會傳回下列資訊。fn_helpcollations returns the following information.

資料行名稱Column name 資料類型Data type 描述Description
名稱Name sysnamesysname 標準定序名稱Standard collation name
描述Description Nvarchar (1000)nvarchar(1000) 定序的描述Description of the collation
[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 支援 Windows 定序。[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports Windows collations. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]也支援稱為[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]定序的有限數量(<80)定序,這些定序[!include[ssnoversion](.. ./includes/ssnoversion-md.md)]是在支援的="" windows="">also supports a limited number (<80) of="" collations="" called="" [!include[ssnoversion](../../includes/ssnoversion-md.md)]="" collations,="" that="" were="" developed="" before="" [!include[ssnoversion](../../includes/ssnoversion-md.md)]="" supported="" windows=""> [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]定序仍然支援回溯相容性,但不應用於新的開發工作。collations are still supported for backward compatibility, but shouldn't be used for new development work. 如需 Windows 定序的詳細資訊,請參閱 [Windows 定序名稱 (Transact-SQL)](../../t-sql/statements/windows-collation-name-transact-sql.md)。For more information about Windows collations, see [Windows Collation Name (Transact-SQL)](../../t-sql/statements/windows-collation-name-transact-sql.md). 如需定序的詳細資訊,請參閱[定序和 Unicode 支援](../../relational-databases/collations/collation-and-unicode-support.md)。For more information about collations, see [Collation and Unicode Support](../../relational-databases/collations/collation-and-unicode-support.md). ## 範例Examples

下列範例會傳回開頭是 L 字母,而且是二進位排序定序的所有定序名稱。The following example returns all collation names starting with the letter L and that are binary sort collations.

注意

針對 fn_helpcollations ()的 Azure SQL 資料倉儲查詢必須在 master 資料庫中執行。Azure SQL Data Warehouse queries against fn_helpcollations() must be run in the master database.

SELECT Name, Description FROM fn_helpcollations()  
WHERE Name like 'L%' AND Description LIKE '% binary sort';  

以下為結果集。Here is the result set.

Name                   Description  
-------------------    ------------------------------------  
Lao_100_BIN            Lao-100, binary sort  
Latin1_General_BIN     Latin1-General, binary sort  
Latin1_General_100_BIN Latin1-General-100, binary sort  
Latvian_BIN            Latvian, binary sort  
Latvian_100_BIN        Latvian-100, binary sort  
Lithuanian_BIN         Lithuanian, binary sort  
Lithuanian_100_BIN     Lithuanian-100, binary sort  
 
(7 row(s) affected)  

另請參閱See Also

COLLATE (Transact-SQL) COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-sql)COLLATIONPROPERTY (Transact-SQL)
Azure SQL 資料倉儲的資料庫定序支援Database collation support for Azure SQL Data Warehouse