Search code examples
mysqlcollation

mysql check collation of a table

How can I see what collation a table has? I.E. I want to see:

+-----------------------------+
|  table  |     collation     |
|-----------------------------|
| t_name  |  latin_general_ci |
+-----------------------------+
Solution

  • SHOW TABLE STATUS shows information about a table, including the collation.

    For example SHOW TABLE STATUS where name like 'TABLE_NAME'