I have sometime long texts on my Blog, and they are usually truncated wich cause unpredictable results.
How to increase the maximum of characters of the weblog fields?
Moved to Community Help forum by Moderator
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
August 08, 2011 9:44am
Subscribe [3]#1 / Aug 08, 2011 9:44am
I have sometime long texts on my Blog, and they are usually truncated wich cause unpredictable results.
How to increase the maximum of characters of the weblog fields?
Moved to Community Help forum by Moderator
#2 / Aug 08, 2011 2:16pm
You’d need to use something like PHPMyAdmin and change the field type to something like MediumText. Does that help?
#3 / Aug 08, 2011 2:42pm
Sure, what field name ?
#4 / Aug 08, 2011 8:13pm
It depends on which field you want to expand.
Say you’re using the default body field, it’s probably field_id_2 in the exp_weblog_data table.
#5 / Aug 08, 2011 8:56pm
I’ve checked and see nowhere, where I can set a limit ... Data field is ‘text’ but how to set the max. length for the data?
#6 / Aug 10, 2011 5:53pm
Hi, Yves. This really is beyond general EE support. But I made this video for you..
http://www.youtube.com/watch?v=9YMTVvc4NT4
Does that help?
#7 / Aug 10, 2011 5:54pm
Hi Yves,
All MySQL TEXT fields can hold 64KB of text. The next step up would be MEDIUMTEXT, which can hold 16MB (!).
#8 / Aug 10, 2011 7:24pm
Hi Yves,
All MySQL TEXT fields can hold 64KB of text. The next step up would be MEDIUMTEXT, which can hold 16MB (!).
I see. If I set MEDIUMTEXT, all data will be lost ? Is every field will use 64MB even if field is empty?
#9 / Aug 10, 2011 7:52pm
No, it won’t be lost. It will have room to grow. But please do back up the table first, though. You’ll only change the field you need, but each record will be larger.