COLLATIONS table provides
information about collations for each character set.
COLLATIONS table has these
The collation name.
The name of the character set with which the collation is associated.
The collation ID.
Whether the collation is the default for its character set.
Whether the character set is compiled into the server.
This is related to the amount of memory required to sort strings expressed in the character set.
The collation pad attribute, either
PAD SPACE. This attribute affects whether trailing spaces are significant in string comparisons; see Trailing Space Handling in Comparisons.
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
[WHERE COLLATION_NAME LIKE 'wild']