The Information Schema CATALOG table stores information about catalogs on the server, including default character sets and collations.
The Information Schema CATALOG table stores information about catalogs on the server.
It contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
CATALOG_NAME
Catalog name.
DEFAULT_CHARACTER_SET_NAME
Default character set for the database.
DEFAULT_COLLATION_NAME
Default collation.
SCHEMA_COMMENT
Catalog comment
MariaDB [def.test]> SELECT * FROM INFORMATION_SCHEMA.CATALOGS\G
*************************** 1. row ***************************
CATALOG_NAME: c1
DEFAULT_CHARACTER_SET_NAME: latin1
DEFAULT_COLLATION_NAME: latin1_swedish_ci
CATALOG_COMMENT: This is catalog c1
*************************** 2. row ***************************
CATALOG_NAME: cat2
DEFAULT_CHARACTER_SET_NAME: latin1
DEFAULT_COLLATION_NAME: latin1_swedish_ci
CATALOG_COMMENT:
*************************** 3. row ***************************
CATALOG_NAME: def
DEFAULT_CHARACTER_SET_NAME: latin1
DEFAULT_COLLATION_NAME: latin1_swedish_ci
CATALOG_COMMENT: default catalog
...