master database only
syscharsets contains one row for each character set and sort order defined for use by Adaptive Server. One of the sort orders is marked in master..sysconfigures as the default sort order, which is the only one actually in use.
The columns for syscharsets are:
Name |
Datatype |
Description |
|---|---|---|
type |
smallint |
The type of entity this row represents. Numbers from 1001 to 1999 represent character sets. Numbers from 2000 to 2999 represent sort orders. |
id |
tinyint |
The ID for a character set or sort order. A sort order is defined by the combination of the sort order ID and the character set ID (csid). The character set is defined by id, which must be unique. Sybase reserves ID numbers 0 – 200. |
csid |
tinyint |
If the row represents a character set, this field is unused. If the row represents a sort order, this is the ID of the character set that sort order is built on. A character set row with this ID must exist in this table. |
status |
smallint |
Internal system status information bits. |
name |
varchar(30) |
A unique name for the character set or sort order. Can use only the 7-bit ASCII letters A – Z or a – z, digits 0 – 9, and underscores (_), and must begin with a letter. |
description |
varchar(255) |
An optional description of the features of the character set or sort order. |
definition |
image |
The internal definition of the character set or sort order. The structure of the data in this field depends on the type. |
sortfile |
varchar(30) null |
The name of the sort order file. |
Unique clustered index on id, csid
Unique nonclustered index on name
