LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]


A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 - 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.

From MariaDB 10.2.7, JSON is an alias for LONGTEXT. See JSON Data Type for details.

Oracle Mode

In Oracle mode from MariaDB 10.3, CLOB is a synonym for LONGTEXT.

See Also


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.