title: Case Insensitive MySQL Database
body: <p>On my MySQL database, my collation is set to <code>utf8_general_ci</code>. I also checked the collation of table in my database. This should allow for case insensitive queries. However all queries are still are still case sensitive.  </p>
  
  <p>For example, this query will not work if I have the username with the first letter capitalized. </p>
  
  <pre><code>  SELECT * 
    FROM   users 
    WHERE  username = 'test' 
    AND    password = 'test' 
  </code></pre>
  
  <p>I am using MySQL 5.5.27 Community edition. Thanks.</p>