Chapter 15 DBMS-Specific Features
The following extended attributes are defined by default in the MySQL DBMS.
The following extended attributes are available on the MySQL tab:
| Name | Description |
|---|---|
| Character set | Character set (set of symbols and encodings).
Scripting name: CharSet |
| Collation | Collation (set of rules for comparing characters in a character set).
Scripting name: Collate |
| National | A way to indicate that a CHAR column should use UTF8 character set.
Scripting name: National |
| Unsigned | Indicates negative values are not allowed for the column.
Scripting name: Unsigned |
| Retrieve with leading zeros | When displayed, the default padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004.
If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. Scripting name: ZeroFill |
The following extended attributes are available on the Extended Attributes tab:
| Name | Description |
|---|---|
| [none] | Indicates that the index is a full text index.
Scripting name: FullText |
The following extended attributes are available on the Extended Attributes tab:
| Name | Description |
|---|---|
| [none] | When set to True, indicates that the key is unique. False implies that the key allows duplicate values.
Scripting name: ExtUnique |
The following extended attributes are available on the Extended Attributes tab:
| Name | Description |
|---|---|
| [none] | Indicates the type of the database, as specified in the extended attribute type DatabaseType.
Scripting name: DatabaseType |
The following extended attributes are available on the Extended Attributes tab:
| Name | Description |
|---|---|
| [none] | Indicates the reference match type, as specified in the extended attribute type ReferenceMatchType.
Scripting name: ReferenceMatch |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |