Yes to what has been said. Collation needs to be same.
I use utf8_general_ci and make sure that all tables and columns use
that as well as the DB itself.
If you don't have "alter" permissions, you can't do anything about
this. Maybe ask the admin to make the change?
_____________________
Derrick Peavy
derr...@derrickpeavy.com
404-786-5036
“Innovation distinguishes between a leader and a follower.” -Steve Jobs
_____________________
On Oct 28, 2009, at 2:14 PM, Cody Wehunt wrote:
Anyone have any information on the following error:
General error: Illegal mix of collations (utf8_general_ci,IMPLICIT)
and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'
I am working on finding out from the host what version of MySQL is
currently running.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
