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 );
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.
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