Ok, thanks everyone.
For now I changed the offending columns to latin1 and latin1_swedish_ci b/c that seems to be what the server is dictating. And the error is gone. What are the cons for using latin1 over utf8? Foreign character support? If I can't get host to make the change, is there a way to make all text columns match w/o doing it by hand? Thanks, Cody From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Wednesday, October 28, 2009 3:50 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: MySQL Error Yes to what has been said. Collation needs to be same. I use utf8_general_ci and make sure that all tables and columns use that as well as the DB itself. If you don't have "alter" permissions, you can't do anything about this. Maybe ask the admin to make the change? _____________________ Derrick Peavy derr...@derrickpeavy.com 404-786-5036 "Innovation distinguishes between a leader and a follower." -Steve Jobs _____________________ On Oct 28, 2009, at 2:14 PM, Cody Wehunt 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 <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 -------------------------------------------------------------
