Illegal mix of collations
Posted by: Siva Singaram
Date: May 24, 2005 10:20AM

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?

Options: ReplyQuote


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