Qlik Replicate: How to resolve row size too large error while loading into MySQL as target DB

[Sonja_Bauernfeind]

Loading into the target database may fail with the following error:

RetCode: SQL_ERROR SqlState: HY000 NativeError: 1118 Message: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.30]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs; execute create table statement failed,

Resolution

Change any one VARCHAR(4000) to TEXT.

In general, change the latest VARCHAR(4000) (no need to "ENGINE=MyISAM").

Environment

Qlik Replicate