Changeset 35655 for trunk/src/wp-includes/wp-db.php

Timestamp:

11/17/2015 06:12:08 AM (11 years ago)

Author:

pento

Message:

WPDB: Fall back to the connection charset when sanity checking strings.

If DB_CHARSET isn't defined (or is empty), wpdb::$charset will be empty, too. wpdb::strip_invalid_text() assumes that it isn't empty, however, so we need to fall back to the connection character set when we're running our sanity checks.

Fixes #34708.

File:

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

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

@@ -2812 +2812 @@
                     }
 
+                    if ( $this->charset ) {
+                        $connection_charset = $this->charset;
+                    } else {
+                        if ( $this->use_mysqli ) {
+                            $connection_charset = mysqli_character_set_name( $this->dbh );
+                        } else {
+                            $connection_charset = mysql_client_encoding();
+                        }
+                    }
+
                     if ( is_array( $value['length'] ) ) {
-                        $queries[ $col ] = $this->prepare( "CONVERT( LEFT( CONVERT( %s USING $charset ), %.0f ) USING {$this->charset} )", $value['value'], $value['length']['length'] );
+                        $queries[ $col ] = $this->prepare( "CONVERT( LEFT( CONVERT( %s USING $charset ), %.0f ) USING $connection_charset )", $value['value'], $value['length']['length'] );
                     } else if ( 'binary' !== $charset ) {
                         // If we don't have a length, there's no need to convert binary - it will always return the same result.
-                        $queries[ $col ] = $this->prepare( "CONVERT( CONVERT( %s USING $charset ) USING {$this->charset} )", $value['value'] );
+                        $queries[ $col ] = $this->prepare( "CONVERT( CONVERT( %s USING $charset ) USING $connection_charset )", $value['value'] );
                     }