mysql check collation of a table
The above answer is great, but it doesn't actually provide an example that saves the user from having to look up the syntax:
show table status like 'test';
Where test
is the table name.
(Corrected as per comments below.)
SHOW TABLE STATUS
shows information about a table, including the collation.
For example SHOW TABLE STATUS where name like 'TABLE_NAME'