title: MySQL 5.5 losing trailing spaces in query
body: <p>I am building a database in which trailing space is important to the results.  When I query for a result I find that </p>
  
  <pre><code>SELECT * where `field` = 'a ' 
  </code></pre>
  
  <p>Returns a result when there is a field who's value is 'a'.  I want the trailing space to matter in the result set.  I have tried using Char, Varchar, Text, and Blob. I will note that this field is the index of my table.</p>
  
  <p>Can someone show me how to query in a way that makes trailing (and/or leading) spaces count? Do I need to format my table in any special way to make this work?</p>