How to get DB default collation in MySQL?

Question

How I can to discover default collation name of certain DB in MySQL DBMS?

Answer 1

For this, you can do next SQL query to service/special DB "information_schema" of MySQL DBMS: SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='db_name';