title: When to use utf8mb4 (bin, general_ci, unicode_520_ci)?
body: <p>I'm confused about the MySQL Collations and its Encodings, People usualy uses one of these three collations:</p>
  
  <ol>
  <li><strong>utf8mb_bin</strong></li>
  <li><strong>utf8mb4_general_ci</strong></li>
  <li><strong>utf8mb4_unicode_520_ci</strong></li>
  </ol>
  
  <p>What I don't understand is when to use each of these collations when needed, Like for example,</p>
  
  <p>A table for names like this</p>
  
  <pre><code>[id - name]
  </code></pre>
  
  <p>It would only has names characters from different languages like <strong>french, german, latin. . .</strong></p>
  
  <p>Do I use for such a table the collation of <code>utf8mb_bin</code> or stick with <code>utf8mb4_unicode_520_ci</code>,</p>
  
  <p>In other hand, A table for topics of a blog for example:</p>
  
  <pre><code>[id - title - subject]
  </code></pre>
  
  <p>Do I put all the columns collation to <code>utf8mb4_unicode_520_ci</code> or use:</p>
  
  <p><code>utf8mb_bin</code> for <code>title</code></p>
  
  <p><code>utf8mb4_unicode_520_ci</code> for <code>subject</code></p>
  
  <p>Since as I understood, the <code>utf8mb4_unicode_520_ci</code> has some emotes in it that would be used in blogs subjects, Or do I just ignore everything and just use <code>utf8mb4_unicode_520_ci</code> on all?</p>
  
  <p>But overall, What is the point of using these different collations? And How does they affect my results in <code>SELECT</code> queries?</p>
  
  <p>What I would like to know in berif is:</p>
  
  <p>What collation to be used for each of:</p>
  
  <ol>
  <li>names</li>
  <li>titles</li>
  <li>subjects</li>
  <li>emails</li>
  <li>bios</li>
  <li>messages</li>
  <li>usernames</li>
  </ol>