How to define a table to store JSON objects in MySQL database?

Question

I want to store a JSON object in MySQL database(using xampp with mariadb). What should be the data type to store? It gives error if 'json' is used as data type.

Answer 1

Solution is to convert json to string and save as text and re-convert to json after retrieving from database