title: MySQL SELECT DISTINCT is case insensitive?
body: <p>I am trying to cleanup some data that I imported into  MySQL from a pandas dataframe.</p>
  
  <p>some appears as:</p>
  
  <pre><code>VARIABLE
  </code></pre>
  
  <p>others as:</p>
  
  <pre><code>Variable
  </code></pre>
  
  <p>when I use</p>
  
  <pre><code>SELECT DISTINCT
  </code></pre>
  
  <p>it seems that MySQL treats Variable as equivilent to VARIABLE.</p>
  
  <p>When I import this into R though R sees Variable and VARIABLE as different.
  And running</p>
  
  <pre><code>as.factor
  </code></pre>
  
  <p>gives me two factors.
  How can I make MySQL's SELECT DISTINCT case sensitive so that I can detect and fix the data for import into R to analyse?</p>