Syntax\n------\n\nSHOW COLLATION\n    [LIKE 'pattern' | WHERE expr]\n\nDescription\n-----------\n\nThe output from SHOW COLLATION includes all available collations. The LIKE clause, if present on its own, indicates which collation names to match. The WHERE and LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.\n\nSimilar information, including some extra information, can be queried from the Information Schema COLLATIONS table.\n\nNo similar information or extra information can be queried from the Information Schema COLLATIONS table.\n\nSee Setting Character Sets and Collations for details on specifying the collation at the server, database, table and column levels.\n\nThe pad_attribute column (not shown in the examples below) has a value of NO PAD or PAD SPACE. This attribute affects whether trailing spaces are significant in string comparisons. See the INFORMATION_SCHEMA.COLLATIONS table description for more information.\n\n``sql\nSHOW COLLATION LIKE 'utf8mb4_bin'; \n+-------------+---------+------+---------+----------+---------+---------------+ \n| Collation   | Charset | Id   | Default | Compiled | Sortlen | Pad_attribute | \n+-------------+---------+------+---------+----------+---------+---------------+ \n| utf8mb4_bin | utf8mb4 | 46   |         | Yes      | 1       | PAD SPACE     | \n+-------------+---------+------+---------+----------+---------+---------------+\n`\n\nThe pad_attribute` column is not available.\n\nExamples\n--------\n\nSHOW COLLATION LIKE 'latin1%';\n+-------------------------+---------+------+---------+----------+---------+\n| Collation               | Charset | Id   | Default | Compiled | Sortlen |\n+-------------------------+---------+------+---------+----------+---------+\n| latin1_german1_ci       | latin1  |    5 |         | Yes      |       1 |\n| latin1_swedish_ci       | latin1  |    8 | Yes     | Yes      |       1 |\n| latin1_danish_ci        | latin1  |   15 |         | Yes      |       1 |\n| latin1_german2_ci       | latin1  |   31 |         | Yes      |       2 |\n| latin1_bin              | latin1  |   47 |         | Yes      |       1 |\n| latin1_general_ci       | latin1  |   48 |         | Yes      |       1 |\n| latin1_general_cs       | latin1  |   49 |         | Yes      |       1 |\n| latin1_spanish_ci       | latin1  |   94 |         | Yes      |       1 |\n| latin1_swedish_nopad_ci | latin1  | 1032 |         | Yes      |       1 |\n| latin1_nopad_bin        | latin1  | 1071 |         | Yes      |       1 |\n+-------------------------+---------+------+---------+----------+---------+\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation