how to check the charset and collation of mysql database?

Question

how to check the charset and collation of mysql database? or what command to the charset and collation of mysql database?

Thanks

Answer 1

Try,

SHOW CREATE DATABASE database-name

And for seeing the collation of tables inside,

SHOW CREATE TABLE table-name