phpMyAdmin 中文亂碼處理方法

到達 phpMyAdmin/libraries/select_lang.lib.php

找到以下的文字,utf8 用 'utf-8' =>'latin1' 取代即可

// MySQL charsets map
$mysql_charset_map = array(
'big5' => 'big5',
'cp-866' => 'cp866',
'euc-jp' => 'ujis',
'euc-kr' => 'euckr',
'gb2312' => 'gb2312',
'gbk' => 'gbk',
'iso-8859-1' => 'latin1',
'iso-8859-2' => 'latin2',
'iso-8859-7' => 'greek',
'iso-8859-8' => 'hebrew',
'iso-8859-8-i' => 'hebrew',
'iso-8859-9' => 'latin5',
'iso-8859-13' => 'latin7',
'iso-8859-15' => 'latin1',
'koi8-r' => 'koi8r',
'shift_jis' => 'sjis',
'tis-620' => 'tis620',
// 'utf-8' => 'utf8',
'utf-8' =>'latin1',
'windows-1250' => 'cp1250',
'windows-1251' => 'cp1251',
'windows-1252' => 'latin1',
'windows-1256' => 'cp1256',
'windows-1257' => 'cp1257',
);

如果是開發 PHP 程式用

$DB_HOST = "localhost"; //資料庫主機位置
$DB_LOGIN = "root"; //資料庫的使用帳號
$DB_PASSWORD = "xxxxx"; //資料庫的使用密碼
$DB_NAME = "xxxxxx"; //資料庫名稱


$conn = mysql_connect($DB_HOST, $DB_LOGIN, $DB_PASSWORD);
mysql_select_db($DB_NAME);
mysql_query("SET NAMES 'utf8'");
?>