When running this simple query: SELECT fileid FROM test WHERE ecn='0'
MySQL yields this error: #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' The table collation is latin1_swedish_ci. I ran SHOW CREATE TABLE fileid and found this: DEFAULT CHARSET=latin1 at the end. Here is the table layout: fileid int(10) datereceived date scn varchar(11) latin1_swedish_ci ecn varchar(11) latin1_swedish_ci Here is the problem: The table collation was once utf8_general_ci (due to mistake), it was switched back to latin1_swedish_ci. Ever since then I've had this error. Suggestions for getting the table back in line? Thanks, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
