Flower

I took this photo 20 years ago and I thought it was goodlogo

This website uses cookies

We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.

By clicking either option below, you are consenting to the use of these cookies. You may select “Show Details” to see details of these cookies. You may withdraw or change your consent in the future here. Please see our Privacy Policy and our Cookie Policy for additional information.

Continue using necessary cookies only Allow all cookies Show details

Knowledge BaseContactLogin Search

PRODUCTS

SERVICES

PRICING

RESOURCES

ABOUT US

DOWNLOAD

Knowledge Base » Library » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Data Types » String Data Types » LONGTEXT

Home

Open Questions

MariaDB Server

MariaDB MaxScale

MariaDB ColumnStore

Connectors

Created

9 years ago

Modified

11 months ago

Type

article

Status

active

License

GPLv2 fill_help_tables.sql

History

Comments

Edit

Attachments

No attachments exist

Localized Versions

LONGTEXT [it]

Product Versions

MariaDB starting with 10.3

MariaDB starting with 10.3

LONGTEXT

Syntax

LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

Contents

Syntax

Description

Oracle Mode

See Also

Description

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

MariaDB starting with 10.3

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

See Also

TEXT

BLOB and TEXT Data Types

Data Type Storage Requirements

JSON Data Type

Oracle mode from MariaDB 10.3

← MEDIUMTEXT

↑ String Data Types ↑

JSON Data Type →

Comments

Include Archived

No comments

↑ String Data Types ↑

String Literals

CHAR

VARCHAR

BINARY

CHAR BYTE

VARBINARY

TINYBLOB

BLOB

BLOB and TEXT Data Types

MEDIUMBLOB

LONGBLOB

TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT

JSON Data Type

ENUM

SET Data Type

Supported Character Sets and Collations

Character Sets and Collations

Data Type Storage Requirements

ROW

BLOB Operations

Products

MariaDB Platform

MariaDB Platform Managed Service

ClustrixDB

Pricing

Downloads

Services

Enterprise Architect

Migration Practice

Remote DBA

Consulting

Technical Support Services

Training

Resources

Blog

Events

OpenWorks 2019

Roadshow

Support

About MariaDB

Leadership

Partners

Contact

Newsroom

Investors

Careers

Contact

Subscribe to our newsletter!

YOUR EMAIL ADDRESS

Add Me

Legal Privacy Policy Cookies

Copyright © 2019 MariaDB. All rights reserved.