表COLLATION_CHARACTER_SET_APPLICABILITY表示哪种字符集适用于哪种排序规则。
INFORMATION_SCHEMA NameSHOW NameCOLLATION_NAMECollationCHARACTER_SET_NAMECharset表COLLATION_CHARACTER_SET_APPLICABILITY包含以下列：
COLLATION_NAME：排序规则名称CHARACTER_SET_NAME：与排序规则关联的字符集名称。COLLATION_CHARACTER_SET_APPLICABILITY列等同于SHOW COLLATION语句显示的前两列。
示例
mysql> select * from information_schema.collation_character_set_applicability WHERE COLLATION_NAME LIKE 'utf8mb4%'; +------------------------+--------------------+ | COLLATION_NAME | CHARACTER_SET_NAME | +------------------------+--------------------+ | utf8mb4_general_ci | utf8mb4 | | utf8mb4_bin | utf8mb4 | | utf8mb4_unicode_ci | utf8mb4 | | utf8mb4_icelandic_ci | utf8mb4 | | utf8mb4_latvian_ci | utf8mb4 | | utf8mb4_romanian_ci | utf8mb4 | | utf8mb4_slovenian_ci | utf8mb4 | | utf8mb4_polish_ci | utf8mb4 | | utf8mb4_estonian_ci | utf8mb4 | | utf8mb4_spanish_ci | utf8mb4 | | utf8mb4_swedish_ci | utf8mb4 | | utf8mb4_turkish_ci | utf8mb4 | | utf8mb4_czech_ci | utf8mb4 | | utf8mb4_danish_ci | utf8mb4 | | utf8mb4_lithuanian_ci | utf8mb4 | | utf8mb4_slovak_ci | utf8mb4 | | utf8mb4_spanish2_ci | utf8mb4 | | utf8mb4_roman_ci | utf8mb4 | | utf8mb4_persian_ci | utf8mb4 | | utf8mb4_esperanto_ci | utf8mb4 | | utf8mb4_hungarian_ci | utf8mb4 | | utf8mb4_sinhala_ci | utf8mb4 | | utf8mb4_german2_ci | utf8mb4 | | utf8mb4_croatian_ci | utf8mb4 | | utf8mb4_unicode_520_ci | utf8mb4 | | utf8mb4_vietnamese_ci | utf8mb4 | +------------------------+--------------------+ 26 rows in set (0.00 sec)转载于:https://www.cnblogs.com/wanbin/p/9514646.html
相关资源：JAVA上百实例源码以及开源项目