First, select your database. If you are working from the command line:
Then, run the SHOW VARIABLES statement against your database, using a LIKE conditional to narrow down to what we want to see:
SHOW VARIABLES LIKE 'character_set_database' SHOW VARIABLES LIKE 'collation_database'
These two statements will return the corresponding values that you are interested in.
If you want to see even more of the settings on your database, just run: