AppDB patch: Request for UTF8-encoded results from MySQL when querying the bugs DB.

Alexandru Balut alexandru.balut at
Sun Apr 25 08:40:55 CDT 2010

Partial fix for bug -
some characters from the bug summary do not appear correctly when a
linked bug is displayed in the page showing a version of an app. For
example, see
and look in that page for bug 21156.

Tested in Chrome, and Firefox, with the following chars in the title:
Iñtërnâtiônàlizætiøn 素晴らしい翻訳はここ笑
-------------- next part --------------
diff --git a/include/query.php b/include/query.php
index 9527fb8..7b02e79 100644
--- a/include/query.php
+++ b/include/query.php
@@ -130,6 +130,12 @@ function query_bugzilladb($sQuery,$sComment="")
         $hBugzillaLink = mysql_connect(BUGZILLA_DBHOST, BUGZILLA_DBUSER, BUGZILLA_DBPASS, true);
         if(!$hBugzillaLink) return;
         mysql_select_db(BUGZILLA_DB, $hBugzillaLink);
+        // Tell MySQL to return UTF8-encoded results
+        $sQueryAskingForUtf8Results = "SET SESSION CHARACTER_SET_RESULTS = 'utf8'";
+        if (!mysql_query($sQueryAskingForUtf8Results, $hBugzillaLink))
+        {
+            query_error($sQueryAskingForUtf8Results, "", $hBugzillaLink);
+        }
     $hResult = mysql_query($sQuery, $hBugzillaLink);

More information about the wine-patches mailing list