Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Character limit for #__fields.fieldparams #43929

Closed
keep opened this issue Aug 16, 2024 · 3 comments
Closed

Character limit for #__fields.fieldparams #43929

keep opened this issue Aug 16, 2024 · 3 comments

Comments

@keep
Copy link

keep commented Aug 16, 2024

#__fields.fieldparams is a TEXT field in the database with a maximum length of 65,535 characters. When I use a List type field with options, Joomla! stores it as JSON, like this:

{"header":"","multiple":1,"options":{"options0":{"name":"My Option 1","value":"My Option 1},"options1":{"name":"My Option 2","value":"My Option 2"}}}

When I need a lot of options, especially if they are a bit longer, it can easily reach the character limit.

What do you think about using MEDIUMTEXT instead of TEXT?

@alikon
Copy link
Contributor

alikon commented Aug 18, 2024

after #42606 it make sense

@fgsw
Copy link

fgsw commented Oct 10, 2024

after #42606 it make sense

@alikon Should it get a Feature-label (#42606 was merged in January 2024)?

@alikon
Copy link
Contributor

alikon commented Oct 12, 2024

please test #44238

@alikon alikon closed this as completed Oct 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants