title: MySQL binary against non-binary for hash IDs
body: <p>Assuming that I want to use a hash as an ID instead of a numeric. Would it be an performance advantage to store them as <code>BINARY</code> over non-binary?</p>
  
  <pre><code>CREATE TABLE `test`.`foobar` (
    `id` CHAR(32) BINARY CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    PRIMARY KEY (`id`)
  )
  CHARACTER SET ascii;
  </code></pre>