Type of string in MySQL

Transferred from: http://computer.uoh.edu.cn/mysql/1677.html

String support types in MySQL are: CHAR, VARCHAR, Tinytext, TEXT, Mediumtext, Longtext, BINARY, VARBINARY, Tinyblog, Mediumblog, BLOG, Longblog, ENUM, set type.

The corresponding lengths of these types (range ranges) are as follows:

Char and Varchar--char length are 0~255 characters, when actually saved, the insufficient part fills 0 to save. The varchar length is 0~65535 characters, and only the length of the input is saved when actually saved.

Binary and varbinary--are the same as char and varchar, but the units are bytes and not characters.

Tinyblob, BLOBs, Mediumblob, and longblob--store binary large objects, which differ only in length, and correspond to the maximum 2^8, 2^16, 2^24, and 2^32 bytes respectively.

Tinytext, TEXT, Mediumtext, and longtext--store string large objects, the difference between them is only the length of the difference, respectively, corresponding to the maximum 2^8, 2^16, 2^24, 2^32 bytes.

enum--enumeration object, up to 65,535.

set--a String object, up to 64.

Type of string in MySQL