You have it backwards. Latin-1 is only 256 characters, UTF-8
conceivably supports up to 4 million or so. Unless you have a need
for internationalization, stick with latin-1.
-dhs
--
Dean H. Saxe
"A true conservationist is a person who knows that the world is not
given by his fathers, but borrowed from his children." -- John James
Audubon
On Oct 28, 2009, at 4:00 PM, Cody Wehunt wrote:
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
