content_image/776344.jpg
A given character set always has at least one collation, and most character sets have several. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS  table or the SHOW COLLATION  statement. 

By default, the SHOW COLLATION  statement displays all available collations. It takes an optional LIKE  or WHERE  clause that indicates which collation names to display. For example, to see the collations for the default character set, utf8mb4 , use this statement: 

mysql> SHOW COLLATION WHERE Charset = ’utf8mb4’; 

<img src='content_image/776344.jpg'>

