This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-23. For the latest, interactive version please visit https://mariadb.com/kb/.

MYSQL_JSON

MariaDB starting with 10.5.7

The TYPE_MYSQL_JSON plugin was first released in MariaDB 10.5.7.

The JSON type in MySQL stores the JSON object in its own native form, while in MariaDB the JSON type is a LONGTEXT. Opening a table with a JSON type created in MySQL would result in an error:

select * from mysql_json_table;
ERROR 4161 (HY000): Unknown data type: 'MYSQL_JSON'

The mysql_json plugin is used to make it easier to upgrade to MariaDB.

Installing

Installing can be done in a number of ways, for example:

install soname 'type_mysql_json';

See Making MariaDB understand MySQL JSON for a full description.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.