The INFORMATION_SCHEMA CHARACTER_SETS Table YES  or  NO , depending on whether the role is mandatory. 26.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table The  CHARACTER_SETS  table provides information about available character sets. The  CHARACTER_SETS  table has these columns: The character set name. The default collation for the character set. A description of the character set. The maximum number of bytes required to store one character. Character set information is also available from the  SHOW CHARACTER SET  statement. See Section 13.7.7.3, “SHOW CHARACTER SET Statement” . The following statements are equivalent: As of MySQL 8.0.16,  CREATE TABLE  permits the core features of table and column  CHECK  constraints, and the the  CHECK_CONSTRAINTS  table provides information about these constraints. The  CHECK_CONSTRAINTS  table has these columns: The name of the catalog to which the constraint belongs. This value is always  def . The name of the schema (database) to which the constraint belongs. The name of the constraint. The expression that specifies the constraint condition. Notes 26.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table 26.3.6 The INFORMATION_SCHEMA COLLATIONS Table 4780 SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE ’ wild ’] SHOW CHARACTER SET [LIKE ’ wild ’] • IS_MANDATORY • CHARACTER_SET_NAME • DEFAULT_COLLATE_NAME • DESCRIPTION • MAXLEN • CONSTRAINT_CATALOG • CONSTRAINT_SCHEMA • CONSTRAINT_NAME • CHECK_CLAUSE