[progress Communities] [progress Openedge Abl] Forum Post: Re: Row Size Too Large (> 8126)

  • Thread starter Thread starter srikanth kasavajhula
  • Start date Start date
Status
Not open for further replies.
S

srikanth kasavajhula

Guest
Hi, If the error comes when the schema is being created , set the property innodb_strict_mode =OFF else the fix to this is to change row format from COMPACT to DYNAMIC so that 768 bytes of each BLOB column (TEXT column) is not counted against the row size limit. But looks like it is not easy to do this in MySQL 5.6/5.5 as changing this needs us to move to Barracuda innodb file format from Antelope innodb file format. Changing innodb file format is at tablespace level and not at table level. We need to upgrade to MySQL 5.7.13 or above and change row format for this issue to go away.

Continue reading...
 
Status
Not open for further replies.
Back
Top