title: String compare exact in query MySQL
body: <p>I created table like that in MySQL:</p>
  
  <pre class="lang-sql prettyprint-override"><code>DROP TABLE IF EXISTS `barcode`;
  CREATE TABLE `barcode` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `code` varchar(40) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  
  INSERT INTO `barcode` VALUES ('1', 'abc');
  
  INSERT INTO `barcode` VALUES ('2', 'abc ');
  </code></pre>
  
  <p>Then I query data from table barcode:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM barcode WHERE `code` = 'abc ';
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>+-----+-------+
  |  id | code  |
  +-----+-------+
  |  1  |  abc  |
  +-----+-------+
  |  2  |  abc  |
  +-----+-------+
  </code></pre>
  
  <p>But I want the result set is only 1 record. I workaround with:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM barcode WHERE `code` = binary 'abc ';
  </code></pre>
  
  <p>The result is 1 record. But I'm using NHibernate with MySQL for generating query from mapping table. So that how to resolve this case? </p>