PHP uses sqlsrv to query a field in a sql2008 data table The field named Chinese does not take a value
Source: Internet
Author: User
PHP uses sqlsrv to query a field named Chinese in a remote sql2008 data table without a value
PHP uses sqlsrv to query a field in a remote sql2008 data table that has a field named Chinese that does not take a value. As shown below:
Query statement:
Select top 1 customid, requirement ID, requirement type, requirement description, resolution time limit, demand submission time, flag, lastmodify from D_ request Submit ORDER by Customid
The results obtained:
Customer number: 500364, request Number: Demand Type: Demand Description: Resolution Time: Demand Submission time: Mark: Last modified: 1014
As shown above: Only Customid and lastmodify take the value
encoding specified when connecting to the library: Characterset=>utf-8
Urgent, online etc!
------Solution--------------------
Escape, yes!
Select top 1 customid,[requirements id],[Requirements Type],[requirements Description],[Resolution Time],[Demand submission time],[flag],lastmodify from [d_ demand submission] ORDER by Customid
You create a query in the controller and you know how to write it.
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.
