(6) Character Set in mysql, Character Set in mysql

(6) Character Set in mysql, Character Set in mysql
Overview

In essence, a computer only recognizes binary code. Therefore, no matter the computer program or the data it processes, it must eventually be converted to binary code before the computer can recognize it. People encode every character symbol for computer identification and processing. This is the origin of the Computer character set.

Select the appropriate Character Set

MySQL5.6 supports dozens of character sets, including UCS-2, UTF-16, UTF-16LE, UTF-32, UTF-8, utf8mb4 and other Unicode character sets, select character set can consider the following factors:

Comparison of common character sets:

MySQL Character Set

The meanings of MySQL Character Set system variables are as follows: