title: Unable to AES_DECRYPT after AES_ENCRYPT in mysql
body: <p>I created user table </p>
  
  <pre><code>CREATE  TABLE `user` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `first_name` VARBINARY(100) NULL ,
  `address` VARBINARY(200) NOT NULL ,
  PRIMARY KEY (`id`))
  ENGINE = InnoDB
  DEFAULT CHARACTER SET = utf8
  COLLATE = utf8_general_ci;
  </code></pre>
  
  <p>I inserted one row:</p>
  
  <pre><code>INSERT into user (first_name, address) VALUES (AES_ENCRYPT('Obama', 'usa2010'),AES_ENCRYPT('Obama', 'usa2010'));
  </code></pre>
  
  <p>To select this row i used:</p>
  
  <pre><code>SELECT AES_DECRYPT(first_name, 'usa2010'), AES_DECRYPT(address, 'usa2010') from user;
  </code></pre>
  
  <p>I am getting the following result.What i need to do see my data.No data is visible for me.</p>
  
  <p><img src="https://i.stack.imgur.com/jqUxS.png" alt="I am unable to see my data"></p>