Class CompatibilitySchema.Charset
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.syscharsets (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains one row for each character set and sort order defined for use by the SQL Server Database Engine. One of the sort orders is marked in sysconfigures as the default sort order. This is the only one actually being used.
See sys.syscharsets.
[Table(Schema = "sys", Name = "syscharsets", IsView = true)]
public class CompatibilitySchema.Charset- Inheritance
-
CompatibilitySchema.Charset
- Extension Methods
Properties
BinaryDefinition
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("binarydefinition")]
[Nullable]
public byte[]? BinaryDefinition { get; set; }Property Value
- byte[]
CSID
If the row represents a character set, this field is unused. If the row represents a sort order, this field is the ID of the character set that the sort order is built on. It is assumed a character set row with this ID exists in this table.
[Column("csid")]
[NotNull]
public byte CSID { get; set; }Property Value
Definition
Internal definition of the character set or sort order. The structure of the data in this field depends on the type.
[Column("definition")]
[Nullable]
public byte[]? Definition { get; set; }Property Value
- byte[]
Description
Optional description of the features of the character set or sort order.
[Column("description")]
[NotNull]
public string Description { get; set; }Property Value
ID
Unique ID for the character set or sort order. Note sort orders and character sets cannot share the same ID number. The ID range of 1 through 240 is reserved for use by the Database Engine.
[Column("id")]
[NotNull]
public byte ID { get; set; }Property Value
Name
Unique name for the character set or sort order. This field must contain only the letters A-Z or a-z, numbers 0 - 9, and underscores(_); and it must start with a letter.
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
Status
Internal system status information bits.
[Column("status")]
[Nullable]
public short? Status { get; set; }Property Value
TypeColumn
Type of entity this row represents:
1001 = Character set.
2001 = Sort order.
[Column("type")]
[NotNull]
public short TypeColumn { get; set; }