How to find out the charset of a database and table with PHPmyAdmin?

Question

Is there a way in PHPMyAdmin to find out the charset of a table and/or a database?

The only thing that ist shown, is the collation. But as far as I understood, the collation only tells the database how to compare the data, and the charset tells the database how to store the data.

Answer 1

Try writing a SQL command:

SELECT * FROM information_schema.SCHEMATA S
WHERE schema_name = "myDataBase";

You might want to check this answer and the comments on this ressoure;

Answer 2

Alternatively, you can also find it by just looking at the collation name itself in most of the cases. Say the collation name is "latin1_swedish_ci" then the character set for the database is "latin1".