How to solve mssql php garbled problem

Solution to mssql php garbled code: 1. Modify the php.ini file and set the utf-8 encoding; 2. Convert the encoding through the iconv function; 3. Use the Ado connection to set the encoding when connecting; 4. Add meta attribute "6b504c8734394304c43c62aef948f340".

The operating environment of this tutorial: Windows 7 system, PHP version 5.6. This method is suitable for all brands of computers.

Recommended: "PHP Video Tutorial"

Solution to garbled characters when querying mssql in php

When php connects to mssql All the results found in the query are garbled characters. I know from experience that this problem is an encoding problem. Let me summarize the solutions for you.

Method 1: Modify the php.ini file. Of course, you can set it according to the situation of your page. It can be utf-8 encoded, 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.");  
?>  
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;") ;   
// 执行查询并输出数据  
$rs = $conn->Execute('SELECT * FROM accounts') or die ("error query"); 
?>  
Statement：
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
Previous article：How to modify data in php formNext article：How to modify data in php form
Related articles
See more
How to solve the garbled problem of php file upload
How to solve php js garbled problem
How to solve the garbled problem of php query
What to do if php Chinese output is garbled?