Category Archives: MySQL

MySQL how to display the character set for a table

Needing the character set details on various tables within a MySQL Database:

SHOW TABLE STATUS

Have a look the MySQL documentation: http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html