select * from he_sm_doc where title like '%Bite%' COLLATE utf8_bin
或者创建表的时候:mysql> create table case_bin_test (word VARCHAR(10)) CHARACTER SET latin1 COLLATE latin1_bin;
Query OK, 0 rows affected (0.02 sec)
select * from he_sm_doc where title like '%Bite%' COLLATE utf8_bin
或者创建表的时候:mysql> create table case_bin_test (word VARCHAR(10)) CHARACTER SET latin1 COLLATE latin1_bin;
Query OK, 0 rows affected (0.02 sec)