How can we check the default character sets of all the MySQL databases we have on the server?

MySQLMySQLi Database

The query below will return the name of the database along with the default character set −

mysql> SELECT SCHEMA_NAME 'Database', default_character_set_name 'charset' FROM information_schema.SCHEMATA;
+--------------------+---------+
| Database           | Charset |
+--------------------+---------+
| information_schema | utf8    |
| gaurav             | latin1  |
| menagerie          | latin1  |
| mysql              | latin1  |
| performance_schema | utf8    |
| sample             | latin1  |
| test               | latin1  |
| tutorial           | latin1  |
+--------------------+---------+
8 rows in set (0.00 sec)
raja
Published on 19-Feb-2018 16:56:13
Advertisements