Row size too large

Hello all,

I am trying to create a table, but I am getting this error message:

Error while creating table :Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs....

Any help??

Hi tannous,

Not really, that a MySQL error that is more or less as it says. It sounds as though you have too many big VARCHAR columns - converting some to TEXT might help.

Bob

Hi guys i m also getting the same error when creating see below, reply with any suggestions.

Error while creating table :Row size too large.

thanks in advance.

Yuyo