开发者

Typo3 Text element not saves my large content. What is the limit of text element?

开发者 https://www.devze.com 2023-03-23 10:01 出处:网络
I created regular Text content element in typo3. My content is huge. Typo3 is not saving whole data, it saves only part of my data.

I created regular Text content element in typo3. My content is huge. Typo3 is not saving whole data, it saves only part of my data.

What is the limi开发者_如何学Pythontation of Text element ?

Typo3 Version 4.4.8


In a standard installation, the bodytext column of the tt_content table is defined as MEDIUMTEXT (equvalent to MEDIUMBLOB) in MySQL. According to this site it can have a maximum length of 16,777,215 characters.

I have not found any other limitation to the text content element in TYPO3, and I just tested this with more than 350,000 characters in a 4.5.2 installation - don't want to be caught writing bogus here :).

However, the MySQL server limits the package size of each query. Read more here

The real maximum size depends on the maximum size allowed by your filesystem (mostly is 2 GB), since is highly unlikely that you can load a 4GB file to the database if your OS allows you only 2GB. [...]. The database engine has a max_allowed_packet limit, which prevents the client from dealing with packets exceeding such barrier

Changing the max_allowed_packet value in my.cnf from it's default 1MB to 32MB or higher might help.

In your case, you should also check for non-standard characters in your text that break the content output of the database field. See here.

0

精彩评论

暂无评论...
验证码 换一张
取 消