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