Hi,

Regarding innodb, someone recently told me:

"the varchar content beyond 768 bytes is stored in supplemental 16K pages"

This is very interesting. If each varchar will be latin1, which I believe stores as 1byte per letter, would a single varchar(500) (<768 bytes) require an extra i/o as a varchar(1000) (>768 bytes) would?? (this question is to find out if all varchars or just big varchars are split into a separate page)

Is the 768 limit per varchar or for all varchars in the row added together? (for example, does this get optimized - varchar(300), varchar(300), varchar(300): [where each individual varchar column is below 768 but together they are above 768 characters]?

I am confused about if the 768 limit relates to each individual varchar or all varchars in the row totaled (as in the question). Any clarification?

EDIT: Removed part about CHARS due to finding out about their limit of 255 max.