in DBMS by (15.1k points)
0 like 0 dislike
22 views

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

1 Answer

0 like 0 dislike
by (15.1k 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 answer this question.