title: MySQL convert to UTF8 without structure change
body: <p>I have a rather large database that I am trying to convert from charset and collation <code>latin1/latin1_swedish_ci</code> to <code>utf8mb4/utf8mb4_unicode_ci</code>. I am hoping to setup replication to a slave, run the conversion, and then promote the slave when finished as to avoid downtime.</p>
  
  <p>I noticed that when running the query...</p>
  
  <pre><code>ALTER TABLE `sometable` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  </code></pre>
  
  <p>...MySQL automatically converts <code>text</code> to <code>mediumtext</code> or <code>mediumtext</code> to <code>longtext</code>, etc.</p>
  
  <p>Is there a way to turn this feature off? It is nice that MySQL has this feature, but the problem is that it breaks replication because the structure of the tables on the slave is different from master.</p>