Thanks I had already checked something similar but per the link below I tried...
alter table `tablename' convert to character set utf8 collate utf8_general_ci; on all 3 tables referenced in the query that is failing and it still produces the same error. Any other ideas? Also if anyone has an idea on how I can run that on all tables that match a certain name , I tried this and it did not work. alter table `mytable_*' convert to character set utf8 collate utf8_general_ci; -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kevin Hellriegel Sent: Wednesday, October 28, 2009 2:21 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: MySQL Error Whoops, forgot to include a link to a thread on the MySQL forums: http://forums.mysql.com/read.php?26,6528,6528#msg-6528 On Wed, Oct 28, 2009 at 2:20 PM, Kevin Hellriegel <khell...@gmail.com> wrote: > 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------