The maximum length of a
VARCHAR is only restricted
by the maximum row length. In most storage engines, the maximum
row length is the maximum allowed by MySQL, which is 65,535
bytes. Only the NDB storage engine has a different maximum value.
VARCHAR data type has some overhead. If the
VARCHAR is less than 255, one byte per row
is used to store the actual length of the string. If the length
VARCHAR is greater than 255, the overhead cost of
storing the string length is two bytes per row. Thus, the maximum
length of a
VARCHAR should be 65,533 bytes.
However, that is not the case:… [Read more...]