Re: Case insensitive search in utf8 db

[Peter Brawley]

Good, it shows your server and its settings are ok for case detection, so the problem is in the design of the db or table you're having problems with.

So please post the results of ...

use dbname;
show variables like 'character%';
show variables like 'collat%';
Show Create Database dbname;
Show Create Table tblname;

... where dbname and tblname are the respective names of the db and table where you're having the problem.