Here are two ways to return the collation of a table in MySQL.
The quickest way to return the collation of a given table in MySQL is to run the following statement:
SHOW TABLE STATUS LIKE '%Artists%';
Running this statement will return a whole bunch of columns that provide information about any matching table/s. One of these columns is called Collation, and it provides the collation of all matching tables.
Of course, you’ll need to replace %Artists%
with your own table name. And you can omit the percentage signs if you don’t think they’re needed. This statement also accepts other clauses, such as FROM
, WHERE
, and IN
, so this gives you some options when building your statement.
Continue reading