title: MySQL SELECT DISTINCT should be case sensitive?
body: <p>How do I make MySQL's SELECT DISTINCT case sensitive?</p>
  
  <pre><code>create temporary table X (name varchar(50) NULL);
  insert into X values ('this'), ('This');
  </code></pre>
  
  <p>Now this query:</p>
  
  <pre><code>select distinct(name) from X;
  </code></pre>
  
  <p>Results in:</p>
  
  <blockquote>
    <p>this</p>
  </blockquote>
  
  <p>What's going on here?  I'd like SELECT DISTINCT to be case sensitive.  Shouldn't that be the default?</p>