數據庫存儲編碼 → 表/字段編碼 → 連接編碼 → PHP 文件編碼 → 頁面輸出編碼 → 瀏覽器解碼
↑ ↑ ↑ ↑ ↑ ↑
必須統一 必須統一 必須統一 必須統一 必須統一 必須統一
; php.ini
; mssql.charset = "ISO-8859-1"
mssql.charset = "GBK" ; 或 UTF-8,視數據庫實際編碼而定
; 重啟 PHP-FPM/Apache 生效
<?php
// 查詢後轉換
$data = iconv('GB2312', 'UTF-8', $row['column']);
// 批量轉換結果集
function convertResultSet(array $rows, string $from = 'GB2312', string $to = 'UTF-8'): array {
return array_map(function($row) use ($from, $to) {
return array_map(fn($v) => is_string($v) ? iconv($from, $to, $v) : $v, $row);
}, $rows);
}
<?php
// 關鍵:new COM 時指定 CP_UTF8 (65001)
$conn = new COM("ADODB.Connection", NULL, CP_UTF8) or die("Cannot start ADO");
$conn->Open("Driver={SQL Server};Server=192.168.22.40;Database=sugarcrm_db;UID=sa;PWD=123456;");
$rs = $conn->Execute('SELECT * FROM accounts');
while (!$rs->EOF) {
// 直接輸出,編碼已由 COM 層處理
echo $rs->Fields['name']->Value . "\n";
$rs->MoveNext();
}
$rs->Close(); $conn->Close();
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"> <!-- 關鍵:頁面聲明 UTF-8 -->
</head>
<body>
<?php
$conn = new COM("ADODB.Connection", NULL, CP_UTF8) or die("ADO啟動失敗");
$conn->Open("Driver={SQL Server};Server=192.168.22.40;Database=sugarcrm_db;UID=sa;PWD=123456;");
$rs = $conn->Execute('SELECT id, name FROM accounts');
?>
<table border="1">
<tr><th>ID</th><th>名稱</th></tr>
<?php while (!$rs->EOF): ?>
<tr>
<td><?= $rs->Fields['id']->Value ?></td>
<td><?= $rs->Fields['name']->Value ?></td>
</tr>
<?php $rs->MoveNext(); endwhile; ?>
</table>
<?php
$rs->Close(); $conn->Close();
?>
</body>
</html>
<?php
$dsn = "sqlsrv:Server=192.168.22.40;Database=sugarcrm_db";
$pdo = new PDO($dsn, 'sa', '123456', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
// 關鍵:設置連接編碼
PDO::SQLSRV_ATTR_ENCODING => PDO::SQLSRV_ENCODING_UTF8
]);
$stmt = $pdo->query('SELECT id, name FROM accounts');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo $row['id'] . ' - ' . $row['name'] . "\n";
}
MSSQL 中文亂碼 99% 是編碼鏈路不一致。老項目用 `mssql.charset` 或 `iconv` 彌補;新項目**強制使用 PDO_SQLSRV + UTF-8 全鏈路**,杜絕亂碼根源。記住:數據庫存什麼編碼,連接就用什麼編碼,頁面就輸出什麼編碼。