mysql column type text often too small

[nicolasfranck]

Please complete the following fields as applicable:

What version of the DMPRoadmap code are you running? (e.g. v2.2.0)

3.0.2

Expected behaviour:

Long texts should fit into text fields

Actual behaviour:

The column type text is limited to 65536 characters, but often people tend to add more data, especially with all the rich content in place as produced by tinymce editors. Why not set to mediumtext or longtext?

[briri]

Do you have an example. We are having trouble imagining a scenario where someone would need to add that much information into an answer or description field.

[nicolasfranck]

Some people are inserting tables with links, styling etc...

that leads to a lot of html; without css that leads to a lot of characters that users are not aware of.

If you give your users a rich text editor, they're going to use it ;-)