CMS Made Simple Forums

Hi,

I am trying to edit a page content using the normal interface (/admin/editcontent.php). I've tried a couple times and each time it truncates the content to a specific length.

I've copied the truncated HTML text in a text editor and realized the length to be 65536 characters. So I went to the database and saw that the data type of the field "content" of table "cms_content_props" is set to TEXT, which according to MySQL (which I am using as my database engine) documentation is 2^16 bytes, or 65536 which corresponds to the length of characters I get.

So now I'm wondering how I can achieve to get more characters on a single page. I could split the content to different pages but that is my worst case scenario. I'd rather have it fit all on a single page.

Is it possible to simply change the data type to MEDIUMTEXT (which would allow 2^24 bytes) and have everything work flawlessly from there? If that is not possible, is there a better/working solution?

Thanks!


4h34d

Yes, changing to MEDIUMTEXT works fine. I've done it for a few sites.

Nullig

We're going to change this so it's the default in the next release.  Again, one of those legacy things that should've been fixed awhile ago.

Thanks for the responses.

Problem was fixed using MEDIUMTEXT as data type.