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.
Limitation of text size?
Re: Limitation of text size?
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.
-
hanso
Re: Limitation of text size?
There is a limitation on the size of a page caused by MySQL type of the content field.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.
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?
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.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!
eternity (n); 1. infinite time, 2. a seemingly long or endless time, 3. the length of time it takes a frozen pizza to cook when you're starving.
4,930,000,000 (n); 1. a very large number, 2. the approximate world population in 1986 when Microsoft Corp issued its IPO. 3. Microsoft's net profit (USD) for the quarter (3 months) ending 31 March 2007.
CMSMS migration and setup services | Hosting with CMSMS installed and ready to go | PM me for Info
4,930,000,000 (n); 1. a very large number, 2. the approximate world population in 1986 when Microsoft Corp issued its IPO. 3. Microsoft's net profit (USD) for the quarter (3 months) ending 31 March 2007.
CMSMS migration and setup services | Hosting with CMSMS installed and ready to go | PM me for Info
-
hanso
Re: Limitation of text size?
Perhaps I have more to tell then you have ...kermit wrote: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.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!
