How can we check the default character set of a specific MySQL database?

The following is a query to check the default character set for a specific MySQL database -

mysql> SELECT SCHEMA_NAME 'DatabaseName', default_character_set_name 'Charset' FROM information_schema.SCHEMATA where schema_name = 'db_name';

Example

For example, the following query will return a query named "Sample "Default character set of the database-

mysql> SELECT SCHEMA_NAME 'DatabaseName', default_character_set_name 'Charset' FROM information_schema.SCHEMATA where schema_name = 'Sample';
+----------------+---------+
| DatabaseName   | Charset |
+----------------+---------+
| Sample         | latin1  |
+----------------+---------+
1 row in set (0.00 sec)

The above is the detailed content of How can we check the default character set of a specific MySQL database?. For more information, please follow other related articles on the PHP Chinese website!