« Cinderella.Man. | 铁拳男人 | 首 页 | 安装记录:hp Proliant DL380 和 Red Hat Enterprise Linux 3.0 »

2006 年 02 月 24 日

phpMyAdmin 的字符显示问题

| 分类: 服务器技术 Server Tech. |

  • phpMyAdmin 版本 phpMyAdmin-2.7.0-pl2
  • MySQL 版本: 4.1.14-log
  • MySQL 的 my.cnf 文件设置:

  • [msyqld] 和 [mysql] 的默认值 default-character-set=latin1 (不需要填写)

  • MySQL shell 的设置确认:
  • mysql> show variables;
    +---------------------------------+----------------------------------------+
    | Variable_name | Value |
    +---------------------------------+----------------------------------------+
    ...
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    ...

  • 去掉语言过滤功能:
  • 在libraries/database_interface.lib.php 文件
    中 Comment out line 548-559 .(图②)
    // and we remove the non-UTF-8 choices to avoid confusion
    if (!defined('PMA_REMOVED_NON_UTF_8')) {
    $tmp_available_languages = $GLOBALS['available_languages'];
    $GLOBALS['available_languages'] = array();
    foreach ($tmp_available_languages AS $tmp_lang => $tmp_lang_data) {
    if (substr($tmp_lang, -5) == 'utf-8') {
    $GLOBALS['available_languages'][$tmp_lang] = $tmp_lang_data;
    }
    } // end foreach
    unset($tmp_lang, $tmp_lang_data, $tmp_available_languages);
    define('PMA_REMOVED_NON_UTF_8',1);
    }

  • 字符设定: config.default.php 文件

  • 默认设置
    /**
    * Language and charset conversion settings
    */
    // Default language to use, if not browser-defined or user-defined
    $cfg['DefaultLang'] = 'en-iso-8859-1';
     
    // Force: always use this language - must be defined in
    // libraries/select_lang.lib.php
    //$cfg['Lang'] = 'en-iso-8859-1';

    强制 en-iso-8859-1 设置(图③)

    /**
    * Language and charset conversion settings
    */
    // Default language to use, if not browser-defined or user-defined
    $cfg['DefaultLang'] = 'en-iso-8859-1';
     
    // Force: always use this language - must be defined in
    // libraries/select_lang.lib.php
    $cfg['Lang'] = 'en-iso-8859-1';
    To be continued...

    (END)

    评论 (1 条)

    Baggio:

    Baggio
    2006年03月01日 03:04

    很有趣的blog 以后要常来`` 呵呵

    发表评论

    (如果您还为在此成功留言,也许是因为需要管理员逐一审核留言内容后放可看到您的评论。请稍后并感谢您的耐心等待。)

    阅览更多文章请访问 首页过去的存档