--disable_warnings drop database if exists bug26017; create database bug26017; --enable_warnings use bug26017; create table table1(f1 varchar(16) collate latin1_swedish_ci primary key, f2 varchar(16) collate latin1_swedish_ci); create table table2(f1 varchar(16) collate latin1_swedish_ci primary key, f3 varchar(16) collate latin1_swedish_ci); insert into table1 (f1, f2) values ('bla', 'blah'); insert into table2 (f1, f3) values ('bla', 'sheep'); select * from table1 left join table2 using(f1) where f1='Bla'; --disable_warnings drop database bug26017; --enable_warnings