Name
LONGTEXT
Syntax
LONGTEXT
Size
0 to 4,294,967,295
Storage
Length of value + 4 bytes
Description
Storage for large text values. While the theoretical limit on the
size of the text that can be stored in a LONGTEXT
column exceeds 4 GB, the practical limit is much less due to
limitations of the MySQL communication protocol and the amount of
memory available on both the client and server ends of the
communication.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.