MySQL like problem, super strong kill Remember!!! _php Tips

Method One:
The workaround is to add the "binary" attribute to the field containing Chinese as a binary comparison, such as changing "name char (10)" to "name char" binary.
Method Two:
If you use the source code to compile MySQL, you can compile MySQL using the--WITH--CHARSET=GBK parameters, so that MySQL will directly support Chinese search and sorting.
Method Three:
You can use the Mysql locate function to determine. Take the above questions for example, using the following methods:
SELECT * FROM table WHERE locate (field, ' Lee ') > 0;
Method Four:
Change your SELECT statement to this, select * from TABLE WHERE FIELDS like BINARY '%find% '

The problem arises because: in MySQL, in the Chinese sorting and search, the Chinese character sorting and search results are wrong. This situation exists in many versions of MySQL. If this problem is not resolved, then MySQL will not be able to actually handle Chinese.
The reason for this problem is: MySQL in the query string is not sensitive to the case, when compiling the MySQL in general with the ISO-8859 character set as the default character set, so in the comparison process of Chinese encoded character case conversion caused this phenomenon