MySQL commands Show table collation from a database: show table status from <database>; Show collation from an entire database;