Solution to garbled characters in php query mssql_PHP tutorial

Solution to garbled characters in php query mssql

The specific analysis is as follows:

When php connects to mssql, all the results are garbled. I know from experience that this problem is an encoding problem. Let me summarize the solution for you.

Method one, modify the php.ini file. Of course, it can be set to UTF-8 encoding according to the situation of your page. The code is as follows:

The code is as follows:

;mssql.charset = "ISO-8859-1"

mssql.charset = "GBK"

Method 2, convert directly in the program, the code is as follows:

The code is as follows:

iconv('GB2312','UTF-8',$data)

Method three, use Ado connection to set the encoding when connecting, the code is as follows:

The code is as follows:

$conn = new COM("ADODB.Connection", NULL, CP_UTF8) or die("Cannot start ADO");

PHP example, the code is as follows:

The code is as follows:

");
//printaline("PLEASE?");
//print("This will not be displayed due to the above error.");
?>
$conn = new COM("ADODB.Connection", NULL, CP_UTF8) or die("Cannot start ADO");
//access database opening method
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
//$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");
$conn->Open("Driver={SQL Server};Server={192.168.22.40};Database=sugarcrm_db;UID=sa;PWD=123456;") ;
//Execute query and output data
$rs = $conn->Execute('SELECT * FROM accounts') or die ("error query");
?>

http://www.bkjia.com/PHPjc/935404.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/935404.htmlTechArticleThe specific analysis of the solution to garbled characters when querying mssql in php is as follows: When php connects to mssql, all the garbled characters are queried. I know from experience that this kind of problem is an encoding problem. Let me tell you...