MySQL error code: 1118 workaround

Error Description:

Error code: 1118
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. Some columns to TEXT or BLOBs

Trans Table Memo varchar (1000) the original field type.

1.ALTER TABLE Trans MODIFY COLUMN Memo TEXT DEFAULT NULL COMMENT ' trading notes ';

2.DEFAULT CHARSET=UTF8MB4-->utf8

This allows the creation of additional varchar fields.

ALTER TABLE Trans ADD COLUMN cpic_coupon_number varchar () DEFAULT NULL COMMENT ' coupon number ';

MySQL error code: 1118 workaround