How to solve mssql garbled characters in php query _ PHP Tutorial

Php query mssql garbled solution. The solution for php mssql query garbled code is as follows: When php is connected to mssql, all the queries are garbled code. I know from experience that this problem is a coding problem, the following is a solution for php to query mssql garbled characters.

The specific analysis is as follows:

When php is connected to mssql, all the queries are garbled characters. I know from experience that this problem is a coding problem. next I will summarize the solution for you.

Method 1: modify the php. ini file. of course, you can set it to UTF-8 based on your page. the code is as follows:

The code is as follows:

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

Mssql. charset = "GBK"

Method 2: convert data directly in the program. The code is as follows:

The code is as follows:

Iconv ('gb2312', 'utf-8', $ data)

Method 3: use Ado Connection to set encoding during connection. 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 ");
// How to open the access database
// $ 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 the query and output data
$ Rs = $ conn-> Execute ('select * FROM accounts') or die ("error query ");
?>

The specific analysis of explain is as follows: All the query results are garbled during php connection to mssql. I know from experience that this problem is a coding problem. I will give it to you below...