title: Collation change utf8mb4_unicode_ci to utf8mb4_general_ci
body: <p>For my databases, I used <code>utf8mb4_unicode_ci</code> with <code>utf8mb4</code> character set as a default. This was a mistake and the folks who are using the databases I created are complaining about the collation. I need to convert it to <code>utf8mb4_general_ci</code>. Am I able to get away with just changing the DB using an alter statement such as:</p>
  <pre><code>ALTER DATABASE `#{database}` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  </code></pre>
  <p>Or, will I need to change each individual table and deal with columns even though the charset is the same between the two collations? I can't seem to find definitive answers on this... I'm using MySQL 5.7.2x .</p>