patilswapnilv / shortcodely

     * @dataProvider data_test_get_table_charset

     * @ticket 21212

     */

    function test_get_table_charset( $drop, $create, $table, $expected_charset ) 

    {

        self::$_wpdb->query($drop);

        if (! self::$_wpdb->has_cap('utf8mb4') && preg_match('/utf8mb[34]/i', $create) ) {

            $this->markTestSkipped("This version of MySQL doesn't support utf8mb4.");

            return;

        }

        self::$_wpdb->query($create);

        $charset = self::$_wpdb->get_table_charset($table);

        $this->assertEquals($charset, $expected_charset);

        $charset = self::$_wpdb->get_table_charset(strtoupper($table));

        $this->assertEquals($charset, $expected_charset);

        self::$_wpdb->query($drop);

    }

    /**

     * @dataProvider data_test_get_column_charset

     * @ticket 21212

     */

    function test_get_column_charset( $drop, $create, $table, $expected_charset ) 

    {

        self::$_wpdb->query($drop);

        if (! self::$_wpdb->has_cap('utf8mb4') && preg_match('/utf8mb[34]/i', $create) ) {

            $this->markTestSkipped("This version of MySQL doesn't support utf8mb4.");

            return;

        }

        self::$_wpdb->query($create);

        foreach ( $expected_charset as $column => $charset ) {

            $this->assertEquals($charset, self::$_wpdb->get_col_charset($table, $column));

            $this->assertEquals($charset, self::$_wpdb->get_col_charset(strtoupper($table), strtoupper($column)));

        }

        self::$_wpdb->query($drop);

    }

    /**