310 Posts
ricco
7 years ago
5
Topic

Hi,

Please tell us how we can insert more than the default 2048 characters in a Free Text Field without loosing the changes after upgrade?

Thanks,

ricco

Get a Book for SEBLOD
4229 Posts
Kadministrator
7 years ago
0
Level 1

You can work around this limitation by activating language feature, so that you only put language key in the freetext field and actual text is stored in langugage file.

cck_core_fields table has defaultvalue column set as varchar(2048) and this is where your limitation comes from. You could change this to e.g. text but this is core table and since it can create problems on future upgrades so this is NOT RECOMMENDED

310 Posts
ricco
7 years ago
3
Level 1

Hi Klas,

I don't understand why there is characters limit in the so called Free Text Field, the better name for it would have been 2048 Chars Field :-). May be the default storage for this field should be changed in the core, what do you think?

The problem is that I'd like to put in it not only text but some mix of html and CB code.

Thank you.

4229 Posts
Kadministrator
7 years ago
2
Level 2

Limit is the size of database column "defaultvalue" as free text value is saved as default fields value.

310 Posts
ricco
7 years ago
1
Level 3

But why?

4229 Posts
Kadministrator
7 years ago
0
Level 4

Normally this is enough, bigger fields slow down database and make it bigger, which can amount to a lot when there are a lot of records.

Get a Book for SEBLOD