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 | Scripting Name | Description |
|---|---|---|
| Character set | CharSet | Character set (set of symbols and encodings). |
| Collation | Collate | Collation (set of rules for comparing characters in a character set). |
| National | National | A way to indicate that a CHAR column should use UTF8 character set. |
| Unsigned | Unsigned | Indicates negative values are not allowed for the column. |
| Retrieve with leading zeros | ZeroFill | 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. |
The following extended attributes are available on the Extended Attributes tab:
| Name | Scripting Name | Description |
|---|---|---|
| [none] | FullText | Indicates that the index is a full text index. |
The following extended attributes are available on the Extended Attributes tab:
| Name | Scripting Name | Description |
|---|---|---|
| [none] | ExtUnique | When set to True, indicates that the key is unique. False implies that the key allows duplicate values. |
The following extended attributes are available on the Extended Attributes tab:
| Name | Scripting Name | Description |
|---|---|---|
| [none] | DatabaseType | Indicates the type of the database, as specified in the extended attribute type DatabaseType. |
The following extended attributes are available on the Extended Attributes tab:
| Name | Scripting Name | Description |
|---|---|---|
| [none] | ReferenceMatch | Indicates the reference match type, as specified in the extended attribute type ReferenceMatchType. |
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |