As shown in the figure, why is there so much encoding in mysql? Can it be modified? What do they mean?

Mysql's character_set_servercannot be modified. Why does mysqlinstanceconfig.exe disappear after 5.6? SETcharacter_set_serverutf8; in this way, latin is changed back after restart. Changing the my. ini file does not work.

Mysql's character_set_server cannot be modified. Why does mysqlinstanceconfig.exe disappear after 5.6?
SET character_set_server = utf8; in this way, latin is changed back after restart.
Changing the my. ini file does not work.

Reply content:

Mysql's character_set_server cannot be modified. Why does mysqlinstanceconfig.exe disappear after 5.6?
SET character_set_server = utf8; in this way, latin is changed back after restart.
Changing the my. ini file does not work.

Encoding is used to adapt to the diversity of languages. It can be modified. Meaning:
Character_set_client: Character Set of the text sent from the client
Character_set_connection: character set for connection
Character_set_server: Server Character Set
Character_set_database: Database Character Set
Character_set_results: character set used for the result sent to the client

Why are there so many encodings? Just like why there are so many countries and so many languages, so many of your codes can be understood as different forms of representation of different languages in computers;

Can it be modified? You can modify the language. If you select the language, your business needs are the language of that country.

What do they mean? [References]

What can be modified. You can only select one of them.
Coding is normal because there are so many countries and so many computer systems.
It's good to remember that this is nothing to study. As long as data transmission and display are not garbled