Changeset 32456

Timestamp:

05/08/2015 12:21:18 PM (9 years ago)

Author:

pento

Message:

Upgrades: If a table has already been converted to utf8mb4, there's no need to try and convert it again.

Props gabrielperezs for the initial patch.

See #32310.

File:

• trunk/src/wp-admin/includes/upgrade.php (modified) (1 diff)

trunk/src/wp-admin/includes/upgrade.php

@@ -1752 +1752 @@
     }
 
+    $table_details = $wpdb->get_row( "SHOW TABLE STATUS LIKE '$table'" );
+    if ( ! $table_details ) {
+        return false;
+    }
+
+    list( $table_charset ) = explode( '_', $table_details->Collation );
+    $table_charset = strtolower( $table_charset );
+    if ( 'utf8mb4' === $table_charset ) {
+        return true;
+    }
+
     return $wpdb->query( "ALTER TABLE $table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci" );
 }