ExpressionEngine textarea increase limit

Question

Scenario:

Client adds newsletters to his website
textarea field cuts off the pasted source code at a particular character count.
Looking at increasing the character count limit for the textarea so that the entire newsletter source code can be pasted.
Using ExpressionEngine 2.5.2

Any thoughts on how to increase the MySQL character limitations? I looked through the channel_fields and tried increasing the row count from 172 to 9999 and the field_settings row to longtext, but this had no effect.

Alex Kendrick · Accepted Answer · 2012-10-27T16:38:29.600

10

Just tested this and the way around this issue is to alter the structure of the exp_chanel_data table itself.

Using PHPMyAdmin, Sequel Pro, or similar, alter the structure of exp_channel_data by changing the data type from TEXT to MEDIUMTEXT on the field that corresponds to your custom field. The field name will be something like field_id_x where X corresponds to the id of the custom field field you are working with.

edited Oct 27 '12 at 16:38

answered Oct 26 '12 at 20:45

Alex Kendrick

969
9
18

1

don't forget to make a backup before proceeding just in case. – CreateSean Oct 26 '12 at 20:45
That's exactly what it was, we weren't looking that the field itself. Thanks again! – Mark Busnelli Jr Oct 26 '12 at 22:43

ExpressionEngine textarea increase limit

1 Answers1