把mysql 4.0.20的数据表文件(myisam)格式迁移到mysql 5.0下面后phpmyadmin出现乱码
如何处理?
共设置了两个地方:
修改: ./libraries/dbi/mysql.dbi.lib.php
修改函数:
function PMA_DBI_connect($user, $password, $is_controluser = FALSE)
注释掉其中的这一行:
PMA_DBI_postConnect($link, $is_controluser);
修改:./libraries/config.default.php
把下面3行修改其值为"gb2312"
/**
* Default language to use, if not browser-defined or user-defined
*
* @global string $cfg['DefaultLang']
*/
//$cfg['DefaultLang'] = 'en-iso-8859-1';
$cfg['DefaultLang'] = 'gb2312';
/**
* Force: always use this language - must be defined in
* libraries/select_lang.lib.php
* $cfg['Lang'] = 'en-iso-8859-1';
*
* Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
* English only
*
* @global string $cfg['FilterLanguages']
*/
//$cfg['FilterLanguages'] = '';
$cfg['FilterLanguages'] = 'gb2312';
/**
* Default character set to use for recoding of MySQL queries, does not take
* any effect when character sets recoding is switched off by
* $cfg['AllowAnywhereRecoding'] or in language file
* (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
*
* @global string $cfg['DefaultCharset']
*/
//$cfg['DefaultCharset'] = 'iso-8859-1';
$cfg['DefaultCharset'] = 'gb2312';