MySQL won't let me create a VARCHAR of size 65535

resetreset · 09-24-2010, 09:28 AM

....but a TEXT field is OK.

Can anyone tell me what's going on?

(this is the latest version of WINDOZE MySQL (sorry!) downloaded from the web.)

suprstar · 09-24-2010, 10:58 AM

You'd have to use a blob or text datatype for anything larger than that. There is a maximum ROW size of 65535 bytes, meaning all your fields combined can't be longer than that. Blobs and text data types get saved off somewhere else, not in the actual record itself, they can be as large as your filesystem allows for.

row length = 1
+ (sum of column lengths)
+ (number of NULL columns + delete_flag + 7)/8
+ (number of variable-length columns)

resetreset · 09-29-2010, 09:15 AM

Thanks a LOT man, I didn't know that!