sql的編碼改成UTF-8轉碼

admin

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

複製代碼