syscharsets

master database only

Description

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.

Columns

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.

Indexes