3

I'm trying to create JSON column in 10.3.16-MariaDB but every time I save the configuration in PHPMyAdmin, the column saves as longtext datatype.

No errors shown :|

Where could be the problem?

System specs: Apache/2.4.39 (Win64) OpenSSL/1.1.1c PHP/7.3.7 and PHPMyAdmin 4.9.0.1 versions

2
  • Apache/2.4.39 (Win64) OpenSSL/1.1.1c PHP/7.3.7 and PHPMyAdmin 4.9.0.1 versions
    – Armand
    Aug 14, 2019 at 18:19
  • Please edit the question and put those extra details in.
    – Vérace
    Aug 14, 2019 at 19:44

1 Answer 1

3

MariaDB does not have a datatype of JSON. Instead it gives you LONGTEXT.

Be aware that there are a lot of differences between MySQL and MariaDB in the area of JSON. Furthermore, different versions of each have different levels of functions, etc.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.