Better to lowercase charset and collation in I_S as before.
Be more careful about various sizes of LOBs.
Somewhat assymmetrical, because BLOB = MySQL BLOB, but CLOB = MySQL LONGCLOB, since TEXT is MySQL CLOB.