WordPress tweaks for MySQL 4.1+ to support different languages

to add support to MySQL 4.1 database with language not set to UTF-8, one must add the following to the wp-includes/wp-db.php file, in function wpdb, at the end:

@mysql_query(’SET NAMES gb2312;’, $this->dbh);
@mysql_query(’SET collation_connection = \’gb2312_chinese_ci\’;', $this->dbh);

Replace “gb2312″ and “gb2312_chinese_ci” to your appropriate settings.