title: Why does MySQL not ORDER as expected?
body: <p>I have a pretty simple MySQL table with team names and id. Team names looks as shown below:</p>
  
  <pre><code>Damer
  F11
  F12
  F15
  Herrar
  HJ18
  HJ20
  P15
  P16
  P11
  P12
  P8
  ...
  </code></pre>
  
  <p>But when I order by ASC or DESC based on teamnames I do not get them in the order i would expect, something like above. Instead I get a list like this:</p>
  
  <pre><code>P15
  P16
  Damer
  F11
  F12
  F15
  Herrar
  HJ18
  HJ20
  P11
  P12
  P8
  ...
  </code></pre>
  
  <p>This makes no sense, why does MySQL start with two names that start with P then one taht starts with D followed by three that starts with F... and finally ends with three teams that start with P again.</p>
  
  <p>Any idea?</p>
  
  <p>MySQL code:</p>
  
  <pre><code>SELECT *
  FROM `team`
  ORDER BY `team`.`teamname` ASC
  LIMIT 0 , 30 
  </code></pre>
  
  <p>And I am using mysql collation utf8_swedish_ci.</p>