Page 1 of 1

Illegal mix of collations

Posted: Sat Apr 21, 2007 2:09 pm
by GeXus
I receive this error using mysql 5...

Illegal mix of collations (utf8_unicode_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'concat'

Any ideas how to fix this? Should i just set all charset to utf8?

Posted: Sat Apr 21, 2007 2:17 pm
by veridicus
When dealing with non-US characters I always store all text as utf-8 so problems like this don't come up. I would switch the latin1 swedish over, but be careful you don't lose any data in the change.

Posted: Sat Apr 21, 2007 5:34 pm
by GeXus
Thanks, that worked..