| Field | Attributes | Description |
|---|---|---|
| CharSetName (TranslateName) | VARCHAR(128) NOT NULL | A name that uniquely identifies a character set. Character set names should start with an unaccented uppercase Roman letter and consist of only unaccented uppercase Roman letters, digits, underscore, dollar sign, or number sign. |
| CharSetID (TranslateID) | BYTEINT NOT NULL | A number that uniquely identifies the character set for which these translation codes are being inserted. Each character set ID must be in the range 65–126. |
| InstallFlag (Install) | CHAR(1) NOT NULL | A value of either Y or N, where:
A maximum of 16 character sets can be enabled at one time. |
| E2I (TranslateIn) | BYTE(256) NOT NULL | The external (host)-to-internal (Database Engine 20) codes for each character in the set. |
| E2IUp (TranslateInUp) | BYTE(256) NOT NULL | The external-to-internal uppercase codes for each character in the set. |
| I2E (TranslateOut) | BYTE(256) NOT NULL | The internal (Database Engine 20)-to-external (client) codes for each character in the set. |
| I2EUp (TranslateOutUp) | BYTE(256) NOT NULL | The internal-to-external uppercase codes for each character in the set. |