I've run into this a few times. Basically it means the charsets in the tables are different and MySQL doesn't like that. You're going to have to change the charset type in one of the tables to match the other.
hth, Kevin On Wed, Oct 28, 2009 at 2:14 PM, Cody Wehunt <c...@wehunt.net> 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 > ------------------------------------------------------------- ------------------------------------------------------------- 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 http://www.fusionlink.com -------------------------------------------------------------