Solution to garbled code in mssql query in php, mssql garbled code

The example in this article describes the solution to the problem of garbled characters when querying mssql in PHP. Share it with everyone for your reference. 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 1, 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:

Copy code 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:

Copy code 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:

Copy code 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:

Copy code 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");
?>

Related labels：

mssql php Garbled characters Solution

source：php.cn

Previous article：Summary of 19 commonly used Android tools, summary of android tools_PHP tutorial Next article：How to convert text files to csv output in php_PHP tutorial

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Solution to garbled code in mssql query in php, mssql garbled code_PHP tutorial

Solution to garbled code in mssql query in php, mssql garbled code