title: MySQL won't ORDER BY Swedish characters åäö not working even though collation is correct
body: <p>This query:</p>
  
  <p><code>SELECT customer_id, customer_name FROM customers WHERE isActive = '1' ORDER BY customer_name ASC</code></p>
  
  <p>Outputs:</p>
  
  <pre><code>+-------------+-----------------------+
  | customer_id | customer_name         |
  +-------------+-----------------------+
  |           1 | Äname                 |
  |           2 | Aname                 |
  |           3 | Bname                 |
  +-------------+-----------------------+
  </code></pre>
  
  <p>Why does it not sort the special swedish characters, even though I have collation <code>utf8_swedish_ci</code></p>
  
  <pre><code>SHOW TABLE STATUS FROM myDatabase WHERE name = 'customers';
  
  +-------------+----------------------------+
  | Name        | Engine   | Collation       |
  +-------------+----------------------------+
  | customers   | MyISAM   | utf8_swedish_ci |
  +-------------+----------------------------+
  </code></pre>
  
  <p>I even tried to put the collation in my query:</p>
  
  <pre><code>SELECT * FROM customers WHERE isActive = 1 COLLATE utf8_swedish_ci ORDER BY customer_name ASC
  </code></pre>
  
  <p>But then I get:</p>
  
  <pre><code>Error Code: 1253. COLLATION 'utf8_swedish_ci' is not valid for CHARACTER SET 'binary'
  </code></pre>