How to solve mssql garbled characters in php query

This article mainly introduces how to query mssql in php and analyzes common solutions for your reference. it is of great practical value, for more information, see the example in this article. Share it with you for your reference. 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 fileOf 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: direct conversion in the programThe code is as follows:

The code is as follows:

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

Method 3: use Ado Connection to set encoding during connectionThe code is as follows:

The code is as follows:

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

PHP exampleThe code is as follows:

The code is as follows:

");
// Printaline ("PLEASE? ");
// Print ("This will not be displayed due to the above error .");
?>
<? Php
$ 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 ");
?>