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
Maximum number of characters in Expresso?
Support (Resolved)
Ralph Bartsch
|
Posted: 04 September 2017 04:24 AM |
|
|
|
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
|
Posted: 04 September 2017 05:36 AM |
# 1
|
|
Developer
|
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
|
Posted: 01 December 2020 03:44 PM |
# 2
|
|
|
May you please let me know where to change the TEXT column from MEDIUMTEXT to LONGTEXT? thanks
|
|
|
PutYourLightsOn
|
Posted: 01 December 2020 04:08 PM |
# 3
|
|
Developer
|
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.
|
|
|