How to get DB default collation in MySQL? asked Jan 14, 2022 in DBMS by Pantycle_Genefanty (15.4k points) 0 like 0 dislike 56 views How I can to discover default collation name of certain DB in MySQL DBMS? collation mysql dbms db sql Please log in or register to add a comment. 1 Answer 0 like 0 dislike answered Jan 14, 2022 by Pantycle_Genefanty (15.4k points) 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'; Please log in or register to add a comment.