Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
GeXus
Forum Regular
Posts: 631 Joined: Sat Mar 11, 2006 8:59 am
Post
by GeXus » Sat Apr 21, 2007 2:09 pm
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?
veridicus
Forum Commoner
Posts: 86 Joined: Fri Feb 23, 2007 9:16 am
Post
by veridicus » Sat Apr 21, 2007 2:17 pm
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 » Sat Apr 21, 2007 5:34 pm
Thanks, that worked..