https://stackoverflow.com › questions › 6766781

LONGTEXT is a string data type with a maximum length of 4,294,967,295 characters. Use LONGTEXT if you need to store large text, such as a chapter of a novel.

https://dev.mysql.com › doc › refman › 8.4 › en › string-type-syntax.html

LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name] A TEXT column with a maximum length of 4,294,967,295 or 4GB (2 32 − 1) characters. The effective maximum length is less if the value contains multibyte characters.

https://dev.mysql.com › doc › refman › 8.0 › en › blob.htm

Learn about the four BLOB and TEXT types in MySQL, their maximum lengths, storage requirements, and how to use them. Find out how to handle binary and nonbinary strings, indexes, defaults, and sorting with BLOB and TEXT columns.

https://www.atlassian.com › data › databases › understanding-strorage-sizes-for-mysql-text...

Learn how to choose the right TEXT data object type for your long-form text strings in MySQL. Compare the storage sizes and capacities of TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, and see examples of usage and tips.

https://dev.mysql.com › doc › refman › 8.0 › en › storage-requirements.html

The internal representation of a table has a maximum row size of 65,535 bytes, even if the storage engine is capable of supporting larger rows. This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size.

https://www.basedash.com › blog › mysql-text-data-types-lengths

Learn how to choose and use the right text data type for your MySQL database based on the expected size of the data. Find out the maximum length of each type, from TINYTEXT to LONGTEXT, and how to implement them in SQL.

https://tableplus.com › blog › 2018 › 04 › mysql-maximum-storage-size-tinytext-text-mediumtext...

Here’s the difference in maximum storage size of each datatype:

https://electrictoolbox.com › maximum-length-mysql-text-field-types

MySQL supports 4 TEXT field types (TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT) and this post looks at the maximum length of each of these field types. MyISAM tables in MySQL have a maximum size of a row of 65,535 bytes, so all the data in a row must fit within that limit.

https://www.mysqltutorial.org › mysql-basics › mysql-text

LONGTEXT – 4GB (4,294,967,295 characters) The LONGTEXT can store text data up to 4GB, which is quite big in common scenarios. It has 4 bytes overhead. Summary. Use the TEXT data type to store long texts in the database.

https://mariadb.com › kb › en › longtext

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.