On 3/26/07, Anil D <adoppalapudi@zustek.com> wrote:
>
>
>
> Varchar = 0 bytes


I don't think this is right, see below.

Charset used: UTF8


UTF8 means that some characters may be two bytes, see below.

Note: When consider even the size Varchar(m) = m+1 bytes, the size of row
> has reached 35,000 bytes.


Here is my guess, but I can't say for sure because I'm still a little new to
this all. The row length doesn't exclude VARCHAR, only TEXT and BLOBs. If
you take that into account as well as your encoding requiring two bytes per
character, then a VARCHAR(50) is going to take up (50*2)+4 = 104 bytes.

Either way, since mysql thinks it's too large, it must be to large. I would
suggest converting several VARCHAR fields to TEXT and see what happens.

-Josh