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
-------------------------------------------------------------



Reply via email to