JSON Type

In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS:

A synonym of LONGTEXT with a default json_valid() CHECK (check added in MariaDB Community Server 10.4.3).

In 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

See LONGTEXT

See also: Data Types in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

CHANGE HISTORY

Release Series

History

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Added in MariaDB Community Server 10.3.1.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.7.

EXAMPLES

CREATE TABLE json_example (
  example JSON
);

SHOW CREATE TABLE json_example\G

*************************** 1. row ***************************
       Table: json_example
Create Table: CREATE TABLE `json_example` (
  `example` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`example`))
) ENGINE=InnoDB DEFAULT CHARSET=latin1

EXTERNAL REFERENCES