CLOB

In Oracle mode, CLOB is an alias for the LONGTEXT data type used to store large text objects.

Overview

This is a synonym for LONGTEXT.

EXAMPLES

SET sql_mode='oracle';

CREATE TABLE clob_example (
  example CLOB
);

SHOW CREATE TABLE clob_example\G

*************************** 1. row ***************************
       Table: clob_example
Create Table: CREATE TABLE "clob_example" (
  "example" longtext DEFAULT NULL
)

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}