1. +--------------------+---------+-----+---------+----------+---------+
    2. | COLLATION          | CHARSET | ID  | DEFAULT | COMPILED | SORTLEN |
    3. +--------------------+---------+-----+---------+----------+---------+
    4. | utf8mb4_general_ci | utf8mb4 |  45 | Yes     | Yes      |       1 |
    5. | binary             | binary  |  63 | Yes     | Yes      |       1 |
    6. | gbk_chinese_ci     | gbk     |  28 | Yes     | Yes      |       1 |
    7. | gbk_bin            | gbk     |  87 | NULL    | Yes      |       1 |
    8. | utf16_general_ci   | utf16   |  54 | Yes     | Yes      |       1 |
    9. | utf8mb4_unicode_ci | utf8mb4 | 224 | NULL    | Yes      |       1 |
    10. | utf16_unicode_ci   | utf16   | 101 | NULL    | Yes      |       1 |
    11. | gb18030_chinese_ci | gb18030 | 248 | Yes     | Yes      |       1 |
    12. | gb18030_bin        | gb18030 | 249 | NULL    | Yes      |       1 |
    13. 11 rows in set (0.01 sec)