Its not the tables that are causing the issue. It is the collation of the individual columns.
On Wed, Oct 28, 2009 at 2:42 PM, Cody Wehunt <c...@wehunt.net> wrote: > 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 > ------------------------------------------------------------- > > > > -- -- if you've written a homegrown[*CFML] controller layer that rivals the sophistication and ease of use of the three major players (MG/MII/FB) - then share it or shut up. You code in a silo - that's great. Just stay in there and don't try to tell everyone how good it smells. --Dave Ross