Is there a way to expand, enlarge a field after creation?

I have a field for a content type which is now too little, but it seems not possible to enlarge after it contains data.

I was thinking to try to edit the number in the database, but could not find out where. And might that ruin the content if possible?

I could of course create another larger field, but hate to move data for hundreds of pages.

Most helpful answers

Hi Egmund, I guess this is a text field, right? Instead of allowing more characters you could change the field settings to allow multiple values, so that an editor has the option to use the option "Add another item" (option name from memory).

Comments

Hi Edmund. What type of field, and what do you mean by "enlarge"?

It is a field containing a link to another site. 'Enlarge'? I set it to 200 chars, but I need more. Reason is to put all centers for one person into one field instead of an unsorted list.

You can see it here - the field call 'Center' in this view: https://zenteachers.org/members-of-azta
If you scroll down to 'Bishop' you can see an example.

Olafski's picture

Hi Egmund, I guess this is a text field, right? Instead of allowing more characters you could change the field settings to allow multiple values, so that an editor has the option to use the option "Add another item" (option name from memory).

Thank you Olaf, that is what I did.

Only reason for putting it all in one 'value' was more tight display.

But I will stick with this suggestion.

I think Olaf's suggestion is probably best for your use case. Multiple values will be much cleaner and less error prone than a long field with multiple values.

I have once enlarged a simple text field and I had to change the field_data_field_field_machine_name table and the

field_revision_field_field_machine_name table but there might well have been other steps that I have forgotten.  I remember it being tricky to do and to deploy.  You might also have issues if you are changing the database field type and/or the Backdrop field type.

It is very much a case of "Here be dragons".  If you do attempt it, make a full backup of your database AND config before so you can recover if it goes wrong.

Yes, that would be too much 'hacking' for me.

I will stick with 'multiple values'