The length can be specified as a value from 0 to 65,535.
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.
- dev.mysql.com/doc/refman/8.4/en/char.html#:~:text=The%20length%20can%20be%20specified%20as%20a%20value%20from%200%20to%2065%2C535.%20The%20effective%20maximum%20length%20of%20a%20VARCHAR%20is%20subject%20to%20the%20maximum%20row%20size%20(65%2C535%20bytes%2C%20which%20is%20shared%20among%20all%20columns)%20and%20the%20character%20set%20used
- archive.is/vCE1p#selection-2709.46-2713.128
- web.archive.org/web/20240801154812/https://dev.mysql.com/doc/refman/8.4/en/char.html#:~:text=The%20length%20can%20be%20specified%20as%20a%20value%20from%200%20to%2065%2C535.%20The%20effective%20maximum%20length%20of%20a%20VARCHAR%20is%20subject%20to%20the%20maximum%20row%20size%20(65%2C535%20bytes%2C%20which%20is%20shared%20among%20all%20columns)%20and%20the%20character%20set%20used