[wp-trac] [WordPress Trac] #32212: Multisite Sites Cannot Create Database tables in 4.2.1 fresh clean install

[WordPress Trac]

#32212: Multisite Sites Cannot Create Database tables in 4.2.1 fresh clean install
--------------------------+------------------------
 Reporter:  reidbusi      |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.2.1
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:  multisite
--------------------------+------------------------

Comment (by dd32):

 As for why this is fixed via #32127 here's the deal:
  * setup-config.php sets `DB_CHARSET` as `utf8mb4` in the event of `(
 'utf8mb4' === $wpdb->charset || ( ! $wpdb->charset && $wpdb->has_cap(
 'utf8mb4' ) ) )` (Namely, the 2nd part comes into play here)
  * WordPress Single-site installs fine, as it uses `utf8mb4` charset, and
 has no `collate` defined, so doesn't include any in it's `CREATE TABLE`
 commands, just the `DEFAULT CHARACTER SET utf8mb4`.
  * WordPress Multisite is a bit different however, Multisite '''always'''
 sets a collate defaulting to `utf8_general_ci`, If it breaks from
 `wpdb::init_charset()` before the collate is fixed to utf8mb4, then all
 `CREATE TABLE`'s that Multisite create will include `DEFAULT CHARACTER SET
 utf8mb4 COLLATE utf8_general_ci` which isn't going to work.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/32212#comment:14>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform