LONGTEXT
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Xpand
Overview
String for variable-length text data.
USAGE
LONGTEXT
[{CHARACTER SET | CHARSET} <charset_name>]
[COLLATE <collation_name>]
DETAILS
SYNONYMS
The following are synonyms for LONGTEXT:
CLOB
EXAMPLES
LONGTEXT
Example of LONGTEXT:
CREATE TABLE longtext_example (
description VARCHAR(20),
example LONGTEXT CHARACTER SET latin1
) DEFAULT CHARSET=latin1;
Note that the size of a LONGTEXT data can be 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.