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

Timestamp:

04/28/2016 01:38:31 AM (9 years ago)

Author:

ericlewis

Message:

Database: Set MySQL connection collation.

Fixes #36649.

File:

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

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

@@ -17 +17 @@
     public static function setUpBeforeClass() {
         require_once( dirname( dirname( __FILE__ ) ) . '/db.php' );
-        
+
         self::$_wpdb = new wpdb_exposed_methods_for_testing();
     }
@@ -892 +892 @@
         $this->assertEquals( $safe_query, $stripped_query );
     }
+
+    /**
+     * @ticket 36649
+     */
+    function test_set_charset_changes_the_connection_collation() {
+        self::$_wpdb->set_charset( self::$_wpdb->dbh, 'utf8', 'utf8_general_ci' );
+        $results = self::$_wpdb->get_results( "SHOW VARIABLES WHERE Variable_name='collation_connection'" );
+        $this->assertEquals( 'utf8_general_ci', $results[0]->Value );
+
+        self::$_wpdb->set_charset( self::$_wpdb->dbh, 'utf8mb4', 'utf8mb4_unicode_ci' );
+        $results = self::$_wpdb->get_results( "SHOW VARIABLES WHERE Variable_name='collation_connection'" );
+        $this->assertEquals( 'utf8mb4_unicode_ci', $results[0]->Value );
+
+        self::$_wpdb->set_charset( self::$_wpdb->dbh );
+    }
 }