title: Illegal mix of collations for operation 'concat'
body: <p>I'm trying to execute this concat query in mysql</p>
  
  <pre><code>SELECT CONCAT(if(fName,fName,''),Name) 
  From Student
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>#1271 - Illegal mix of collations for operation 'concat'</p>
  </blockquote>