Syntax\n------\n\nLONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]\n\nDescription\n-----------\n\nA TEXT column with a maximum length of 4,294,967,295 or 4GB (2³² - 1) characters. The effective maximum length is less if the value contains multi-byte characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in the client/server protocol and available memory. Each LONGTEXT value is stored using a four-byte length prefix that indicates the number of bytes in the value.\n\nJSON is an alias for LONGTEXT. See JSON Data Type for details.\n\nOracle Mode\n\nIn Oracle mode, CLOB is a synonym for LONGTEXT.\n\nExamples\n--------\n\nCREATE TABLE longtext_example (\n   description VARCHAR(20),\n   example LONGTEXT\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/longtext