How to solve mssql php garbled problem-PHP Problem-php.cn

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 "".

How to solve mssql php garbled problem

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"

Copy after login

Method 2, convert directly in the program, the code is as follows:

The code is as follows:

iconv(&#39;GB2312&#39;,&#39;UTF-8&#39;,$data)

Copy after login

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");

Copy after login

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

Summary:

The first is: the database type, including database, table, and fields must be unified, you can check it

The second is: the encoding of the file Type, if you use dw or editplus, you can check the page encoding. If it is different, you need to modify it

The third is: the setting when accessing the database is set NAMES utf8;

The fourth is: browser display mode, add meta attribute

The above is the detailed content of How to solve mssql php garbled problem. For more information, please follow other related articles on the PHP Chinese website!

Related labels：

mssql php

source：php.cn

Previous article：How to modify data in php form Next article：How much does PHP training cost?

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