PHP技术
之前安装博客时未注意数据库编码,导致数据库一直用的latin1_swedish_ci,虽然也能正常使用,但是管理起来不太方便,一直想转成utf8_general_ci。今天得空了,百度了一下,发现一个函数,实际测试有效,执行过后blog的数据库编码已经从latin1_swedish_ci变成了utf8_general_ci,再打开博客自然乱码。不过无妨,编辑/data/config.php,将$db_410='0'修改为$db_410='1',让博客强制使用UTF-8存取数据,再刷新页面,正常了。
<?php
define('DB_NAME', 'putyourdbnamehere');    // 数据库名
define('DB_USER', 'usernamehere');     // MySQL用户名
define('DB_PASSWORD', 'yourpasswordhere'); // 密码
define('DB_HOST', 'localhost');    // 很大可能你无需修改此项

function UTF8_DB_Converter_DoIt() {
  $tables = array();
  $tables_with_fields = array();

  // Since we cannot use the WordPress Database Abstraction Class (wp-db.php),
  // we have to make an a stand-alone/direct connection to the database.
  $link_id = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Error establishing a database connection');
  mysql_select_db(DB_NAME, $link_id);

  // Gathering information about tables and all the text/string fields that can be affected
  // during the conversion to UTF-8.
  $resource = mysql_query("SHOW TABLES", $link_id);
  while ( $result = mysql_fetch_row($resource) )
    $tables[] = $result[0];

  if ( !empty($tables) ) {
    foreach ( (array) $tables as $table ) {
      $resource = mysql_query("EXPLAIN $table", $link_id);
      while ( $result = mysql_fetch_assoc($resource) ) {
        if ( preg_match('/(char)|(text)|(enum)|(set)/', $result['Type']) )
          $tables_with_fields[$table][$result['Field']] = $result['Type'] . " " . ( "YES" == $result['Null'] ? "" : "NOT " ) . "NULL " .  ( !is_null($result['Default']) ? "DEFAULT '". $result['Default'] ."'" : "" );
      }
    }

    // Change all text/string fields of the tables to their corresponding binary text/string representations.
    foreach ( (array) $tables as $table )
      mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET binary", $link_id);

    // Change database and tables to UTF-8 Character set.
    mysql_query("ALTER DATABASE " . DB_NAME . " CHARACTER SET utf8", $link_id);
    foreach ( (array) $tables as $table )
      mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET utf8", $link_id);

    // Return all binary text/string fields previously changed to their original representations.
    foreach ( (array) $tables_with_fields as $table => $fields ) {
      foreach ( (array) $fields as $field_type => $field_options ) {
        mysql_query("ALTER TABLE $table MODIFY $field_type $field_options", $link_id);
      }
    }

    // Optimize tables and finally close the mysql link.
    foreach ( (array) $tables as $table )
      mysql_query("OPTIMIZE TABLE $table", $link_id);
    mysql_close($link_id);
  } else {
    die('<strong>There are no tables?</strong>');
  }

  return true;
}
UTF8_DB_Converter_DoIt();
?>
分页: 1/1 第一页 1 最后页 [ 显示模式: 摘要 | 列表 ]