Mysql query to discover current default database collation (via command line client)

Question

I can't figure out which is the query to run in order to see the current collation set for a mysql database.

I know I can change it running a query like this:

ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name]

but I don't want to do it without knowing the current value.

I think it's actually possible because in phpmyadmin you can see the current value in the operation tab of your database, but I need to do it via the command line client and after googling a little bit I found no answers.

Probably I will open phpmyadmin code to discover it.. before doing it, does anybody know which is the right query?

Thanks in advance.

Answer 1

Figured out by myself, looking at phpmyadmin code.

Depending on mysql version, the query to run is this:

SELECT DEFAULT_COLLATION_NAME FROM data_dictionary.SCHEMAS WHERE SCHEMA_NAME = 'nameOfMyDb' LIMIT 1;

or

SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'nameOfMyDb' LIMIT 1;