On 3/26/07, Anil D <[EMAIL PROTECTED]> 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
