in DBMS by (14.5k points)
0 like 0 dislike

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

1 Answer

0 like 0 dislike
by (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 answer

Try to answer the question as detailed as possible.
Your name to display (optional):
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.