I'm trying to execute this concat query in mysql

SELECT CONCAT(if(fName,fName,''),Name) 
From Student

Error:

#1271 - Illegal mix of collations for operation 'concat'

mysql sql
Edit
Report