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 |
Set of symbols and encodings. Scripting name: CharSet |
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 |