The 1.mysql character set has detailed settings:
The 2.mysql character processing mechanism is that there is a character set converter between the database and the client (the later abbreviation Converter) converts the client character encoding (which must be told to the server) into an intermediate encoded data (customizable but guaranteed that the conversion does not lose data) and then into the database-defined encoding, When fetching data, the converter converts the intermediate encoding to the desired return encoding (customizable).
Set the character encoding type of the notification server client
3. Garbled and Missing cases
In fact, the above mentioned coding, including encoding and decoding.
Types of character sets supported by queries:
4. Proofing set: Collation of characters. A character set can have multiple proofing sets.
4.1 Viewing the supported proofing sets:
4.2 Defining the proofing set must correspond to the character Set mode:
MySQL Overview (ix) character sets and proofing sets