executed and the server
can see what datatype the column actually has).

Lengths
-------

If you're running queries like:

SELECT COLUMN_GET(blob, 'colname' as CHAR) ...

without specifying a maximum length (i.e. using as CHAR, not as CHAR(n)),
MariaDB will report the maximum length of the resultset column to be
16,777,216. This may cause excessive memory usage in some client libraries,
because they try to pre-allocate a buffer of maximum resultset width. To avoid
this problem, use CHAR(n) whenever you're using COLUMN_GET in the select list.

See Dynamic Columns:Datatypes for more information about datatypes.

URL: https://mariadb.com/kb/en/column_get/https://mariadb.com/kb/en/column_get/