Solution to garbled characters in php query mssql_PHP tutorial-PHP Tutorial-php.cn

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:

//print("The next line generates an error.www.jb51.net
");
//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 specific Appear analyze method Inquire of solve

source：php.cn

Previous article：PHP uses PDO to operate MySQL database instance, pdomysql database instance_PHP tutorial Next article：PHP calls mysql stored procedure instance analysis, mysql instance analysis_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