Sql-server to MySQL migration woes- maximum rowsize cannot exceed 65,535 bytes

Question

I am migrating the database layer of our application from MSSQL to MySQL and came across this exception when I tried to migrate an MSSQL table to MySQL:

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)

Turns out the MSSQL table has lots of nvarchar columns leading of a effective row size much larger than 65535. This only way I could think of to overcome this is to change my application design to split the large table into smaller ones and this redesign isn't something I am looking forward to.

Is there any way to overcome this without application redesign?

Thanks in advance.
Bharath K.

Answer 1

According to MySQL's doc: The internal representation of a table also has a maximum row size of 65,535 bytes, even if the storage engine is capable of supporting larger rows. So you just cannot have such a table.

You should analyze your original table's data to change some column's length. Or make some columns of your target MySQL table 'TEXT'