Method One:
The workaround is to add the "binary" attribute to the field that contains the Chinese as a binary comparison, for example, change "name char (10)" to "name Char (TEN) binary".
Method Two:
If you compile MySQL using the source code, you can compile MySQL using the--WITH--CHARSET=GBK parameter, so that MySQL will support the Chinese search and sort directly.
Method Three:
You can use Mysql's locate function to judge. Take the above problem as an example, using the following method:
SELECT * FROM table WHERE locate (field, ' Lee ') > 0;
Method Four:
Change your SELECT statement to this, select * from TABLE WHERE fields like BINARY '%find% ' can
The problem arises because, in MySQL, the sorting and finding of Chinese characters is wrong when sorting and searching in Chinese. This situation is present in many versions of MySQL. If this problem is not resolved, then MySQL will not be able to actually handle Chinese.
This problem occurs because MySQL is case insensitive when querying strings, and when Yi MySQL is generally used as the default character set for the ISO-8859 character set, this behavior is caused by the Chinese encoding character-case conversion during the comparison.
http://www.bkjia.com/PHPjc/317782.html www.bkjia.com true http://www.bkjia.com/PHPjc/317782.html techarticle method One: The workaround is to add the "binary" attribute to the field containing the Chinese as a binary comparison, for example, change "Namechar (10)" to "Namechar (ten) binary". Method Two: If you use ...
