LONGTEXT
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Enterprise Server
Topics on this page:
Overview
String for variable-length text data up to 4,294,967,295 bytes.
DETAILS
SYNONYMS
The following are synonyms for LONGTEXT:
CLOB
JSON
EXAMPLES
LONGTEXT
Example of LONGTEXT
:
CREATE TABLE longtext_example (
description VARCHAR(20),
example LONGTEXT
) DEFAULT CHARSET=latin1; -- One byte per char makes the examples clearer
Note that the maximum size of a LONGTEXT
is so large that it cannot be sent to the server without breaking the value up into chunks (something that the command-line client cannot do). For values larger than 16M you can increase the max_allowed_packet
size up to a maximum of 1024M to increase the allowed size of non-chunked values.
INSERT INTO longtext_example VALUES
('Normal foo', 'foo'),
('Trailing spaces foo', 'foo '),
('NULLed', NULL),
('Empty', ''),
('Maximum', RPAD('', 4294967295, 'x'));
ERROR 1301 (HY000): Result of rpad() was larger than max_allowed_packet (16777216) - truncated
Data Too Long
When SQL_MODE
is strict (the default) a value is considered "too long" when its length exceeds the size of the data type, and an error is generated.
Example of data too long behavior for LONGTEXT
:
TRUNCATE longtext_example;
INSERT INTO longtext_example VALUES
('Overflow', RPAD('', 4294967296, 'x'));
ERROR 1301 (HY000): Result of rpad() was larger than max_allowed_packet (16777216) - truncated
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.