title: How to store hashes in MySQL databases without using text fields
body: <p>I'm storing unique <strong>user-agents</strong> in a MySQL MyISAM table so when I have to look if it exists in the table, I check the <strong>md5 hash</strong> that is stored next to the TEXT field.</p>
  
  <pre><code>User-Agents 
  {
      id         - INT
      user-agent - TEXT
      hash       - VARCHAR(32) // md5
  }
  </code></pre>
  
  <p>There is any way to do the same but using a 32-bit integer and not a text hash? Maybe the md5 in raw format will be faster? That will requiere a binary search.</p>
  
  <p>[EDIT]</p>
  
  <p>MySQL don't handle hash searches for complete case-sensitive strings?</p>