Smaller text columns
But VARCHAR is supposed to go up to 65,535 so why doesn’t
VARCHAR(65,535)
work?!
It works. It doesn’t give you an error on the column. But there is a limit for the entire table row size (the sum of all column sizes) as well.
Like the error tells you
The maximum row size for the used table type, not counting BLOBs, is 65535.
So you could create a column with varchar(65535) but it would have to be the only column in the table.