方法一，修改php.ini檔案 (當然根據你頁面情況來設定也可以是utf-8編碼了。
| 代碼如下 | 複製代碼 |
;mssql.charset = "ISO-8859-1" |
|
方法二，直接程式中轉換
| 代碼如下 | 複製代碼 |
iconv('GB2312','UTF-8',$data) |
|
方法三，利用Ado串連在串連時設定編碼
$conn = new COM(“ADODB.Connection”, NULL, CP_UTF8) or die(“Cannot start ADO”);
例子
| 代碼如下 | 複製代碼 |
| •<html> •<head> •<meta http-equiv=“Content-Type” content=“text/html; charset=utf-8″> •</head> •<body> •<?php •//print(“The next line generates an error.www.111Cn.net<br>”); •//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”); •//access 資料庫的開啟檔案 •//$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;”) ; •// 執行查詢並輸出資料 •$rs = $conn->Execute(‘SELECT * FROM accounts’) or die (“error query”); •?> •<table border=“1″> •<tr><th>ID</th><th>Title</th> •</tr> •<?php •while (!$rs->EOF) { • echo ‘<tr>’; • echo ‘<td>’. $rs->Fields['id']->Value .‘</td>’; • echo ‘<td>’. $rs->Fields['name']->Value .‘</td>’; • echo ‘</tr>’; • $rs->MoveNext(); •} •?> •</table> •<?php •// 釋放資源 •$rs->Close(); •$conn->Close(); •$rs = null; •$conn = null; • •?> •</body> •</html> |
|
總結
一是：資料庫類型，其中包括，資料庫，表，欄位三處都要統一，可以檢查一下
二是：檔案的編碼類別型，你若用dw或editplus可以查看頁面編碼，不同需修改
三是：訪問資料庫時的設定既set NAMES utf8;
四是：瀏覽器顯示方式，添加meta屬性<meta charset=utf-8>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
