sys.syscharsets (Transact-SQL)sys.syscharsets (Transact-SQL)

适用于:Applies to: 是 SQL ServerSQL Server (所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是的Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是的Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW)yesAzure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW) 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是 SQL ServerSQL Server (所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是的Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是的Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW)yesAzure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW) 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

每个字符集都占一行,其中还包含定义以供 SQL Server 数据库引擎SQL Server Database Engine使用的排序顺序。Contains one row for each character set and sort order defined for use by the SQL Server 数据库引擎SQL Server Database Engine. 其中一个排序顺序在sysconfigures中标记为默认的排序顺序。One of the sort orders is marked in sysconfigures as the default sort order. 此排序顺序是实际使用的唯一排序顺序。This is the only one actually being used.

列名称Column name 数据类型Data type 说明Description
typetype smallintsmallint 此行表示的实体的类型:Type of entity this row represents:

1001 = 字符集。1001 = Character set.

2001 = 排序顺序。2001 = Sort order.
idid tinyinttinyint 字符集或排序顺序的唯一 ID。Unique ID for the character set or sort order. 请注意,排序顺序和字符集不能共享相同的 ID 号。Note sort orders and character sets cannot share the same ID number. 从 1 至 240 的 ID 范围是保留给数据库引擎Database Engine使用的。The ID range of 1 through 240 is reserved for use by the 数据库引擎Database Engine.
csidcsid tinyinttinyint 如果行表示字符集,则不使用此字段。If the row represents a character set, this field is unused. 如果行表示排序顺序,则此字段为排序顺序据以生成的字符集的 ID。If the row represents a sort order, this field is the ID of the character set that the sort order is built on. 假设此表中存在具有此 ID 的字符集行。It is assumed a character set row with this ID exists in this table.
statusstatus smallintsmallint 内部系统状态信息位。Internal system status information bits.
namename sysnamesysname 字符集或排序顺序的唯一名称。Unique name for the character set or sort order. 此字段必须只包含字母 A-Z 或 a-z、数字 0 - 9 以及下划线 (),并且必须以字母开始。This field must contain only the letters A-Z or a-z, numbers 0 - 9, and underscores(); and it must start with a letter.
2008description nvarchar(255)nvarchar(255) 字符集或排序顺序功能的说明(可选)。Optional description of the features of the character set or sort order.
binarydefinitionbinarydefinition varbinary(6000)varbinary(6000) 标识为仅供参考。Identified for informational purposes only. 不支持。Not supported. 不保证以后的兼容性。Future compatibility is not guaranteed.
definitiondefinition 图像image 字符集或排序顺序的内部定义。Internal definition of the character set or sort order. 此字段中的数据结构取决于类型。The structure of the data in this field depends on the type.

另请参阅See Also

将系统表映射到系统视图 (Transact-sql) Mapping System Tables to System Views (Transact-SQL)
兼容性视图 (Transact SQL)Compatibility Views (Transact-SQL)