MySQL Character set

Character Set length encoding method description

Acsii is the first groundbreaking character set of single-byte 7-bit encoding

Iso-8859-1/latin1 is a single-byte, 8-bit coded Western European character set, often used by some programmers to transcode

GB2312-80 is an early standard for double-byte encoding and is not recommended for reuse

GBK is a double-byte encoding although not GB, but the supported system is quite

GB 18030 No 2-byte or 4-byte encoding starts with some support, but database support is also rare

The UTF-32 is a 4-byte encoded UCS-4 raw code that is rarely used

UCS-2 is a 2-byte encoding for Windows 2000 internal UCS-2

UTF-16 No 2-byte or 4-byte encoding for internal use such as Java and Windows Xp/nt UTF-16

UTF-8 No 1 to 4 bytes encoded on the internet and unix/linux widely supported Unicode character sets; MySQLServer also uses UTF-8

MySQL Character set