Changeset 37523

Timestamp:

05/23/2016 06:31:44 AM (9 years ago)

Author:

pento

Message:

Database: Use the utf8mb4_unicode_520_ci collation, when available.

The utf8mb4_unicode_520_ci (Unicode Collation Algorithm 5.2.0, October 2010) collation is an improvement over utf8mb4_unicode_ci (UCA 4.0.0, November 2003).

There is no word on when MySQL will support later UCAs.

Fixes #32105.

File:

• trunk/src/wp-includes/wp-db.php (modified) (3 diffs)

trunk/src/wp-includes/wp-db.php

@@ -765 +765 @@
                 $this->collate = str_replace( 'utf8_', 'utf8mb4_', $this->collate );
             }
+        }
+
+        // _unicode_520_ is a better collation, we should use that when it's available.
+        if ( $this->has_cap( 'utf8mb4_520' ) && 'utf8mb4_unicode_ci' === $this->collate ) {
+            $this->collate = 'utf8mb4_unicode_520_ci';
         }
     }
@@ -3194 +3199 @@
      * @since 2.7.0
      * @since 4.1.0 Support was added for the 'utf8mb4' feature.
+     * @since 4.6.0 Support was added for the 'utf8mb4_520' feature.
      *
      * @see wpdb::db_version()
@@ -3232 +3238 @@
                     return version_compare( $client_version, '5.5.3', '>=' );
                 }
+            case 'utf8mb4_520' :  // @since 4.6.0
+                return version_compare( $version, '5.6', '>=' );
         }