title: combine string with column name in query with sha1
body: <p>I would like to hash the passwords in my database with another column of the same table. I have been trying to do this with a query, but I keep getting the same error.</p>
  
  <p>This is an example query I use for testing the login. 12345678 is the password and I want to use the email address as a hash.</p>
  
  <pre><code>SELECT * FROM users WHERE
  SHA1(CONCAT('12345678', `email`)) = password
  </code></pre>
  
  <p>When I execute this in mysql I get the following error:</p>
  
  <pre><code>#1267 - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '='
  </code></pre>