How to use like to match inaccurate Chinese Characters in MySQL

Method 1:

The solution is to add the "binary" attribute to a field that contains Chinese characters for Binary comparison. For example, change "name char (10)" to "name char (10) binary ".

Method 2:

If you use the source code to compile MySQL, you can use the -- with -- charset = GBK parameter when compiling MySQL, so that MySQL can directly support Chinese searching and sorting.

Method 3:

You can use MySQL LoCATe function. The preceding problem is used as an example:

Select * from table where locate (FIELD, 'lil')> 0;

Method 4:

Change your select statement to this way. Select * from table where fields like binary '% find % '.

The cause of the problem is:

In MySQL, Chinese Character sorting and search results are incorrect. This situation exists in many MySQL versions. If this problem is not solved, MySQL cannot actually process Chinese characters.

MySQL is case-insensitive when querying strings, and generally uses the ISO-8859 character set as the default character set when programming mysql. Therefore, the case-sensitivity conversion of Chinese Encoded Characters During the comparison process causes this phenomenon.