Illegal mix of collations
Hi,
I am running the following query
Select Name,Income from report
Union
Select "Grand Total" as Name, Sum(Income) as Income From Report
And I get the following error when I run from the command line client.
1267 ** Illegal mix of collations (utf8_general_ci,EXPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'
When I run it from the phpMySQLAdmin, I do not get any errors. I am running version 4.1.12 on CentOS 4. What could be wrong here?
Subject
Views
Written By
Posted
Illegal mix of collations
25713
May 24, 2005 10:20AM
13143
May 24, 2005 11:47AM
8178
May 24, 2005 08:12PM
7405
May 25, 2005 11:11AM
6697
April 25, 2008 01:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.