How to get DB default collation in MySQL? asked Jan 14 in DBMS by Pantycle_Genefanty (14.5k points) 0 like 0 dislike 8 views How I can to discover default collation name of certain DB in MySQL DBMS? collation mysql dbms db sql Your comment on this question: Your name to display (optional): Email me at this address if a comment is added after mine:Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications. Anti-spam verification: To avoid this verification in future, please log in or register. 1 Answer 0 like 0 dislike answered Jan 14 by Pantycle_Genefanty (14.5k 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'; Your comment on this answer: Your name to display (optional): Email me at this address if a comment is added after mine:Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications. Anti-spam verification: To avoid this verification in future, please log in or register.
