Database error when setting too many use flags.

[ch4ika]

Server Implementation

Paper

Server Version

1.20.1

Describe the bug

When setting many use materials in flags, the database error occurs.

To Reproduce

Just add as many materials in the Use flag.

Expected behaviour

MySQL value limited to varchar 512

Screenshots / Videos

No response

Error log (if applicable)

No response

Plot Debugpaste

https://paste.gg/p/anonymous/3f819349c91048e5813e3b1a53c95f88

PlotSquared Version

PlotSquared-7.0.0 RC3

Checklist

• I have included a Plot debugpaste.
• I am using the newest build from https://www.spigotmc.org/resources/77506/ and the issue still persists.

Anything else?

No response

[RedstoneFuture]

#2686

[PierreSchwang]

#2686

Seems like it was not fixed in v5 lol (or just implemented again). The create statement still assigns a VARCHAR(512) for the flag value

[dordsor21]

Well since we used 512 not 511 anyway, we've got almost an entire byte of space we're not using