Funky Error during select.

[Chris Cline]

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.