MySQL - Get Database Character Set and Collation

You can use the following query to see the database character set and collation:

-- Read database character sets and collations
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;

Sample output:

Additionally, you can execute the following query to get the character set and collation for the current database:

USE <db_name>;
SELECT @@character_set_database, @@collation_database;

Sample output:

latin1

latin1_swedish_ci