title: Magento change database query collation
body: <p>I have a <code>Magento 1.5.1.0</code> installation, and some of the products in the catalog has swedish characters at the start of the product name. This causes an incorrect sort when sorting by name. Ä and Å becomes A, and Ö becomes O.</p>
  
  <p>This means the sorting will be like:</p>
  
  <pre><code>A
  Å
  Ä
  B
  [...]
  </code></pre>
  
  <p>This is because the database is using the collation <code>utf8_general_ci</code>. I've found you can override what collation MySQL uses when executing a query, but I just can not find a good way to get it into the Magento code. Should this perhaps be done on the Zend level?</p>