mysql>
mysql> SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME,
-> DEFAULT_COLLATION_NAME
-> FROM INFORMATION_SCHEMA.SCHEMATA;
+--------------------+----------------------------+------------------------+
| SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+--------------------+----------------------------+------------------------+
| information_schema | utf8 | utf8_general_ci |
| mysql | latin1 | latin1_swedish_ci |
| test | latin1 | latin1_swedish_ci |
+--------------------+----------------------------+------------------------+
3 rows in set (0.00 sec)
mysql>