The like fuzzy query conditions cannot be output. extra points

Source: Internet
Author: User
The like fuzzy query conditions cannot be output, online, etc !! Plus points & lt ;? Php & nbsp; $ conn = mysql_connect (& quot; localhost & quot;, & quot; root & quot;, & quot;); if (! $ Conn) {& adding like fuzzy query conditions cannot be output, online, etc !! Extra points

$ Conn = mysql_connect ("localhost", "root ","");
If (! $ Conn ){
Die ("failed to connect to database:". mysql_error ());
} Else {
Echo "connected to the database! ";
}
Mysql_query ("set character set utf8 ");

$ Yes = mysql_select_db ("ORG7188", $ conn );
If (! $ Yes ){
Die ("failed to connect to the database :");
} Else {
Echo "connected to the database! ";
}
$ SQL = "SELECT * FROM 188_line where ts like '% %'"; // You can output content without the where statement.
$ Socret = mysql_query ($ SQL, $ conn );

While ($ row = mysql_fetch_array ($ socres )){
Echo $ row [ts];

}

?>

The database is as follows:



------ Solution --------------------

Select * from table where filds like binary \ '% Chinese % \'
------ Solution --------------------
What is the php code? The code, database, and browser are encoded as UTF-8.
------ Solution --------------------
Let's take a look.
....

$ SQL = "SELECT * FROM 188_line where ts like '% %'"; // You can output content without the where statement.
Die (base64_encode ($ SQL); // add this sentence and paste the result

$ Socret = mysql_query ($ SQL, $ conn );

------ Solution --------------------
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.

The cause of this problem is: MySQL is case insensitive when querying strings, in programming MySQL, the ISO-8859 character set is generally used as the default character set, therefore, the case-sensitivity conversion of Chinese encoding characters during the comparison process causes this phenomenon.

Method 1:
The solution is to add the \ "binary \" attribute to a field that contains Chinese characters to make it a binary comparison. for example, use \ "name char (10 )\"; change 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.
------ Solution --------------------
Discussion

Reference:
Let's take a look.
....

$ SQL = "SELECT * FROM 188_line where ts like '% %'"; // You can output content without the where statement.
Die (base64_encode ($ SQL); // add this sentence and paste the result

$ Socret = mysql_query ($ SQL, $ conn );



Error syntax err ......

------ Solution --------------------
Discussion

It should be because the php file is not UTF-8 encoded.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.