Fieldtype

Developer
Supported

Expresso

ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5

Back to this add-on's main page
View Other Add-ons From PutYourLightsOn

     

You must be logged in to post.

Maximum number of characters in Expresso?

Support (Resolved)

Ralph Bartsch
Ralph Bartsch

Is there a maximum number of characters in expresso? text cuts of over aprox 54000 characters.
EE: 3.5.10
Expresso: 4.2.4

PutYourLightsOn
# 1
Developer
PutYourLightsOn

Yes, by default the Expresso field content is stored in the database as a TEXT column (like a textarea or rich text editor field) which has a limit of 65,535 characters. If you need to store more then you can do so by changing the column to MEDIUMTEXT or LONGTEXT, as per the limits below:
TEXT: 65,535 characters
MEDIUMTEXT: 16,777,215 characters
LONGTEXT: 4,294,967,295 characters

harthouse
# 2
harthouse

May you please let me know where to change the TEXT column from MEDIUMTEXT to LONGTEXT? thanks

PutYourLightsOn
# 3
Developer
PutYourLightsOn

It will be the `field_id_X` column in the database table called `exp_channel_data_field_X`, where `X` is the value of the `field_id` column in the `exp_channel_fields` table.