title: MySQL comparison between 'æ' and 'ae'
body: <p>My MySQL server doesn't recognize the difference between characters 'æ' and 'ae' while storing data to database and that creates some problems for me. My goal is to find a charset which recognizes the difference between those characters, and I found it (utfmb3), but it is going to be deprecated, and the new alternative (utfmb4) doesn't recognize those characters as different.</p>
  <p>What I've tried:</p>
  <pre><code>set names 'utf8mb3';
  select 'æ' = 'ae';
  </code></pre>
  <p>This select returns <code>0</code> (false), which means this charset sees these as different characters, and that's just what I need, but MySQL gives me a warning:
  <em>'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead</em></p>
  <p>But when I do</p>
  <pre><code>set names 'utf8mb4';
  select 'æ' = 'ae';
  </code></pre>
  <p>This select returns <code>1</code>, which means <code>utf8mb4</code> sees these as the same characters, which is not good..</p>
  <p>So, my dilema is, what charset to use?
  If I use <code>utfmb3</code>, it will be deprecated soon, that's no good. If I use <code>utfmb4</code>, that won't work correctly.</p>