New to the community? Start here

multi_db 3.0.7 class have character issue

Hiya everyone,

I upgrade this plugin and then I get character issue.

You can look image.

I guess this class have some problem.

[attachments are only viewable by logged-in members]

Thu, 22 Sep 2011 0:36:35
  • Mustafa
    • Syntax Hero

    I fix problem.But I report this bug before

    db.php line 207-217

    if ( $this->has_cap( 'collation' ) && !empty( $this->charset ) ) {
    
if ( function_exists( 'mysql_set_charset' ) ) {
    
mysql_set_charset( $this->charset, $this->dbhglobal );
    
$this->real_escape = true;
    
} else {
    
$query = $this->prepare( 'SET NAMES %s', $this->charset );
    
if ( ! empty( $this->collate ) )
    
$query .= $this->prepare( ' COLLATE %s', $this->collate );
    
$this->query( $query );
    
}
    
}

    change with

    mysql_query('SET NAMES UTF8');
    
mysql_query("SET CHARACTER SET utf8");
    
mysql_query('SET COLLATION_CONNECTION=utf8_general_ci');

    I guess first loop not working correctly.

    Please note this bug and fix for next releases,

    Thanks.