JSON Type
Topics on This Page:
- 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 |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
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
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the JSON page in the SkySQL Documentation.