[SOLVED] Page content gets truncated

[4h34d]

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

[Nullig]

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

Nullig

[Ted]

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.

[4h34d]

Thanks for the responses.

Problem was fixed using MEDIUMTEXT as data type.