TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT

A character large object that can hold a variable amount of case-insensitive text data.

TINYTEXT

A character large object column with a maximum length of 255 (2^8 - 1) characters.

TEXT

A character large object column with a maximum length of 65535 (2^16 - 1) characters.

MEDIUMTEXT

A character large object column with a maximum length of 16777215 (2^24 - 1) characters.

LONGTEXT

A character large object column with a maximum length of 4294967295 (2^32 - 1) characters.