Hello.
Please, send us an output of the following statements: show variables like '%char%'; show variables like '%collation%'; "Stembridge, Michael" <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
