Thread

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

You’d need to use something like PHPMyAdmin and change the field type to something like MediumText. Does that help?

Sure, what field name ?

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.

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?

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?

Hi Yves,

All MySQL TEXT fields can hold 64KB of text. The next step up would be MEDIUMTEXT, which can hold 16MB (!).

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?

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.