Json Column configuration
Pick either TEXT or Json, based on the needs.
TEXT (up to 64KB) or MEDIUMTEXT (up to 16MB) plus FULLTEXT indexing is useful for very efficient seraching for &quot;words&quot; in unstructured prose.  There are limits on what a &quot;word&quot; is -- in length and in avoiding &quot;stop words&quot; such as &quot;the&quot;.
JSON is for structured text, usually key-value pairs, possibly arrays and associative arrays.  But the search capabilities are limited.  What specific version of MariaDB (or MySQL) do you expect to use?
To help you further, we really need some insight into the type of data and application.