title: MySQL DISTINCT and whitespace
body: <p>Consider the following queries</p>
  
  <pre><code>INSERT INTO DummyTable (TextColumn) VALUES ('Text');
  INSERT INTO DummyTable (TextColumn) VALUES ('Text ');
  
  SELECT DISTINCT TextColumn FROM DummyTable
  </code></pre>
  
  <p>Notice that the second insert contains a whitespace: 'Text '</p>
  
  <p>But DISTINCT ignores the space and returns only one row 'Text' - how do you make DISTINCT not to ignore the whitespace?</p>