patternsqlMinor
JSON field saves as longtext datatype
Viewed 0 times
longtextfielddatatypejsonsaves
Problem
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
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
Solution
MariaDB does not have a datatype of
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.
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.
Context
StackExchange Database Administrators Q#245357, answer score: 3
Revisions (0)
No revisions yet.