Hi,

Currently I am developing some component to help students log their progress.
I am adding functionilty to add a snapshot, which is a filtered list of records, saved as json.

In another component which reads ships from a webservice I alos come across this missing feature:

When adding a text of json field, the DB is created as TEXT.
But as you can imagine, a lot of text or a long list of jsonobejcts is larger then the 64 Kilobytes of of TEXT field.
In MySQL there are also the MEDIUMTEXT (16MB) and LONGTEXT (4 GB)
Also for creating a long blog entry TEXT might be too small.

Is is possible to create a feature when adding a text of json field, the mysql field type can be configured?
Like in the properties dialog in the builder, where you set if the field is required and such.

I do it now in an update post install script, but I'd rather have a little as possible customizing.

Can you give this a check admin?

Hi Admin,

I would like to propose this as a new feature

This is easy to do.

Added since 2.9.5
www.j-cook.pro/index.php/docs/versions/251-2-9-5

Nice, thnx!