Illegal mix of collations

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Illegal mix of collations

Post 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?
User avatar
veridicus
Forum Commoner
Posts: 86
Joined: Fri Feb 23, 2007 9:16 am

Post 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.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

Thanks, that worked..
Post Reply