Sources: mostly here and not so much here.
Something about MySQL being swedish and having a default character set of latin1 and a collation of latin1_swedish_ci which is no good if you need to save utf8 data.
Continue reading How to Fix the Collation and Character Set of a MySQL Database
Error Code: 1118
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
See the possible solutions here:
Get your ‘create table’ sql code and add:
SET GLOBAL innodb_default_row_format='dynamic';
Continue reading Row size too large (> 8126)
SET SESSION innodb_strict_mode=OFF;