Syntax\n------\n\nMEDIUMTEXT [CHARACTER SET charset_name] [COLLATE collation_name]\n\nDescription\n-----------\n\nA TEXT column with a maximum length of 16,777,215 (2²⁴ - 1) characters. The effective maximum length is less if the value contains multi-byte characters. Each MEDIUMTEXT value is stored using\\\na three-byte length prefix that indicates the number of bytes in the value.\n\nSYNONYMS\n\nThe following are synonyms for MEDIUMTEXT:\n\n LONG\n LONG CHAR VARYING\n LONG CHARACTER VARYING\n LONG VARCHAR\n* LONG VARCHARACTER\n\nExamples\n--------\n\nCREATE TABLE mediumtext_example (\n   description VARCHAR(20),\n   example MEDIUMTEXT\n) DEFAULT CHARSET=latin1; -- One byte per char makes the examples clearer\n\nURL: https://mariadb.com/docs/server/reference/data-types/string-data-types/mediumtext