Are you able to view the properties of the table? See if you can verify that both the table and the columns have the same charset. Also, instead of utf8_general_ci try utf8_swedish_ci.
Kevin 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 > ------------------------------------------------------------- > > > > ------------------------------------------------------------- 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 -------------------------------------------------------------
