Funky Error during select.
Posted by: Chris Cline
Date: November 03, 2004 12:34PM

Has anyone encountered this error while performing a Select?

{"#HY000Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" }

I was performing this select when the error was thrown.

SELECT * FROM plant.plant_history WHERE cMonth='05' AND cYear='2004'

Both cMonth and cYear are Char(2) and Char(4) respectivly.

I even renamed cYear and cMonth incase it was causing a parser error with month and year. Same error.

I am using .Net 1.1 with 1.0.1 Beta and MySql 4.1.7

I'd like to point out I copied and pasted the select into the query browser and it worked fine.

Options: ReplyQuote

Written By
Funky Error during select.
November 03, 2004 12:34PM
November 03, 2004 01:20PM
November 03, 2004 01:28PM
November 03, 2004 01:35PM

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.