mysq concat error

Question

User410067686 posted

CONCAT(MONTHNAME(i.time), ' ', YEAR(i.time), c.categoryName)
 
Error Code: 1271. Illegal mix of collations for operation 'concat'

Answer 1

User-1360095595 posted

I believe YEAR() returns an int. So you need to cast that to varchar. 

Answer 2

User410067686 posted

How do I proceed?

Answer 3

User410067686 posted

i.time is a timestamp and categoryName is a varchar

Answer 4

User-1360095595 posted

Try changing this: YEAR(i.time)

To this:  CONVERT(varchar(5), YEAR(i.time))