Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

0

I'm having this error while adding tables to my database. Anyone help me in this situation? Because the data is already like Barracuda.

The fields I am adding are of Type: Text, Varchar (20), Longblob.

    
asked by anonymous 16.06.2014 / 15:17

1 answer

3

Based on Row size too large in mysql create table query , no OS, text translation:

  

The total size of all table fields is more than the limit, 65535, which is why you are getting this error.   You should use the text type instead of varchar for long strings. Replace all varchar (8000) with text, and it should work.   Or, better yet, use appropriate data types rather than the "too big" ones. You do not really need 8000 characters to store currency, do you?

Try to follow this guideline and give us feedback, later on, I've never been there myself, but always have the first time.

    
16.06.2014 / 16:22