Page 1 of 1
Limitation of text size?
Posted: Mon Oct 23, 2006 1:03 am
by glezos
Is there any limitation on the size of text one can put inside the templates and the pages? When I copy/paste in a template or a page's box a big chunk of text, it is truncated during the page rendering, although when editing the page I can see the whole text.
Sorry if this has been answered before, but I've searched and didn't find an answer.
Re: Limitation of text size?
Posted: Mon Oct 23, 2006 1:32 am
by Dee
There's no limit set I think, but it's a TEXT field in the database, for MySQL (from the
MySQL documentation):
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers.
Re: Limitation of text size?
Posted: Sun Dec 09, 2007 11:57 am
by hanso
Dee wrote:
There's no limit set I think, but it's a TEXT field in the database, for MySQL (from the
MySQL documentation):
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers.
There is a limitation on the size of a page caused by MySQL type of the content field.
You can change this with phpMyAdmin
Table cmsmsxcontent_props
Field content
Change Type from TEXT to LONGTEXT
It tells the following query is used to do that change.
ALTER TABLE `cmsmsxcontent_props` CHANGE `content` `content` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
I wonder why the TEXT is choosen, it is rather limited in what a page can contain this way. I had to change this for every CMSMS implementation!
Hans
Re: Limitation of text size?
Posted: Sun Dec 09, 2007 3:42 pm
by kermit
hanso wrote:
I wonder why the TEXT is choosen, it is rather limited in what a page can contain this way. I had to change this for every CMSMS implementation!
EVERY single cmsms site you've done has a content area that exceeds 64k? i've done dozens and host even more.. NONE of them have yet to come close to it.
Re: Limitation of text size?
Posted: Sun Dec 09, 2007 7:00 pm
by hanso
kermit wrote:
hanso wrote:
I wonder why the TEXT is choosen, it is rather limited in what a page can contain this way. I had to change this for every CMSMS implementation!
EVERY single cmsms site you've done has a content area that exceeds 64k? i've done dozens and host even more.. NONE of them have yet to come close to it.
Perhaps I have more to tell then you have ...