MySQL character set and ordering introduction

Customer-side Character set: Character_set_client utf8mb4
Connection Character Set: CHARACTER_SET_CONNECTIONUTF8MB4
Database Character Set: CHARACTER_SET_DATABASEUTF8MB4
File system Character Set: Character_set_filesystembinary
Result Character Set: CHARACTER_SET_RESULTSUTF8MB4
Server Character Set: CHARACTER_SET_SERVERUTF8MB4
Operating system Character set: Character_set_systemutf8
Directory Character set: Character_sets_dir

Processing Chinese: character_set_client Character_set_server is set to GB2312, processing multi-language is set to UTF-8, no setting character_set_results is used by default character _set_client

GB2312 Support Simplified Chinese
GBK Simplified Chinese and Traditional Chinese
BIG5 Pay Traditional Chinese
UTF-8 Support International language, English 8 bit (1 bytes), Chinese 24 bit (3 bytes)

Conversion between GBK, GB2312 and UTF-8
GBK, Gb2312->unicode->utf-8
UTF-8->UNICODE->GBK, GB2312

GB2312 is a subset of GBK, GBK is a subset of GB18030, and GBK is a large character set that contains CJK characters.

Emoji-enabled character set: UTF8MB4

MySQL character set and ordering introduction