title: Error when changing character set in mySQL?
body: <p>I'm trying to change a field in a mySQL database (ver. 5.6.45) from utf8 to utf8mb4 in order to be able to post emojis.</p>
  <p>This is what I'm doing:</p>
  <pre><code>ALTER TABLE contenidos CHANGE COLUMN titulo varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  </code></pre>
  <p>But I also tried (with the same result), this:</p>
  <pre><code>ALTER TABLE contenidos CHANGE COLUMN titulo CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  
  ALTER TABLE contenidos CHANGE COLUMN titulo varchar(500) CHARACTER SET utf8mb4;
  </code></pre>
  <p>I keep getting this error:</p>
  <blockquote>
  <h1>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use</h1>
  <p>near 'CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci' at line 3</p>
  </blockquote>
  <p>If I change trhe collation from phpmyadmin I can do it, but it doesn't seem to work, because the emojis are not saver in the database. So I thought that I should change the charset aswell.</p>