在网上找了篇文章，能临时性解决mysql数据库乱码

cuxnil

最近做网站，服务器用debian系统，发现后台mysql的数据库乱码，网上找了个暂时性的解决方法
把下列文件保存为一个.php文件，然后运行

1. 
   
2. <?php
   
3. define('DB_NAME', 'putyourdbnamehere');    // 数据库名
   
4. define('DB_USER', 'usernamehere');     // MySQL用户名
   
5. define('DB_PASSWORD', 'yourpasswordhere'); // 密码
   
6. define('DB_HOST', 'localhost');    // 很大可能你无需修改此项
   
7. 
   
8. function UTF8_DB_Converter_DoIt() {
   
9.         $tables = array();
   
10.         $tables_with_fields = array();
    
11. 
    
12.         // Since we cannot use the WordPress Database Abstraction Class (wp-db.php),
    
13.         // we have to make an a stand-alone/direct connection to the database.
    
14.         $link_id = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Error establishing a database connection');
    
15.         mysql_select_db(DB_NAME, $link_id);
    
16. 
    
17.         // Gathering information about tables and all the text/string fields that can be affected
    
18.         // during the conversion to UTF-8.
    
19.         $resource = mysql_query("SHOW TABLES", $link_id);
    
20.         while ( $result = mysql_fetch_row($resource) )
    
21.                 $tables[] = $result[0];
    
22. 
    
23.         if ( !empty($tables) ) {
    
24.                 foreach ( (array) $tables as $table ) {
    
25.                         $resource = mysql_query("EXPLAIN $table", $link_id);
    
26.                         while ( $result = mysql_fetch_assoc($resource) ) {
    
27.                                 if ( preg_match('/(char)|(text)|(enum)|(set)/', $result['Type']) )
    
28.                                         $tables_with_fields[$table][$result['Field']] = $result['Type'] . " " . ( "YES" == $result['Null'] ? "" : "NOT " ) . "NULL " .  ( !is_null($result['Default']) ? "DEFAULT '". $result['Default'] ."'" : "" );
    
29.                         }
    
30.                 }
    
31. 
    
32.                 // Change all text/string fields of the tables to their corresponding binary text/string representations.
    
33.                 foreach ( (array) $tables as $table )
    
34.                         mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET binary", $link_id);
    
35. 
    
36.                 // Change database and tables to UTF-8 Character set.
    
37.                 mysql_query("ALTER DATABASE " . DB_NAME . " CHARACTER SET utf8", $link_id);
    
38.                 foreach ( (array) $tables as $table )
    
39.                         mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET utf8", $link_id);
    
40. 
    
41.                 // Return all binary text/string fields previously changed to their original representations.
    
42.                 foreach ( (array) $tables_with_fields as $table => $fields ) {
    
43.                         foreach ( (array) $fields as $field_type => $field_options ) {
    
44.                                 mysql_query("ALTER TABLE $table MODIFY $field_type $field_options", $link_id);
    
45.                         }
    
46.                 }
    
47. 
    
48.                 // Optimize tables and finally close the mysql link.
    
49.                 foreach ( (array) $tables as $table )
    
50.                         mysql_query("OPTIMIZE TABLE $table", $link_id);
    
51.                 mysql_close($link_id);
    
52.         } else {
    
53.                 die('<strong>There are no tables?</strong>');
    
54.         }
    
55. 
    
56.         return true;
    
57. }
    
58. UTF8_DB_Converter_DoIt();
    
59. ?>
    

复制代码

为什么说是临时性的呢？因为你用了这个脚本，数据库里原来的数据不乱码了，但是你新加入的数据依然是乱码，正在寻找方法根本性的解决这个问题

x11

全utf8也乱码？