Changeset 31349 for trunk/tests/phpunit/tests/db/charset.php

Timestamp:

02/06/2015 04:50:19 AM (10 years ago)

Author:

pento

Message:

WPDB: If a site is using the utf8 charset, and their version of MySQL supports utf8mb4, auto-upgrade them to utf8mb4.

This patch also resizes some indexes, to allow for the 767 byte index size limit in standard MySQL installs.

See #21212

File:

• trunk/tests/phpunit/tests/db/charset.php (modified) (2 diffs)

trunk/tests/phpunit/tests/db/charset.php

@@ -131 +131 @@
 
     /**
-     * @ ticket 21212
+     * @ticket 21212
      */
     function test_process_fields_failure() {
         global $wpdb;
-        $data = array( 'post_content' => "H€llo\xf0\x9f\x98\x88World¢" );
+        // \xf0\xff\xff\xff is invalid in utf8 and utf8mb4.
+        $data = array( 'post_content' => "H€llo\xf0\xff\xff\xffWorld¢" );
         $this->assertFalse( self::$_wpdb->process_fields( $wpdb->posts, $data, null ) );
     }
@@ -437 +438 @@
     function test_invalid_characters_in_query() {
         global $wpdb;
-        $this->assertFalse( $wpdb->query( "INSERT INTO {$wpdb->posts} (post_content) VALUES ('foo\xf0\x9f\x98\x88bar')" ) );
+        $this->assertFalse( $wpdb->query( "INSERT INTO {$wpdb->posts} (post_content) VALUES ('foo\xf0\xff\xff\xffbar')" ) );
     }
 }