From e07bef5eef4eabb2934f5f758fa5f73f4cbdacf4 Mon Sep 17 00:00:00 2001
From: lemonsoftwarero <lemonsoftwarero>
Date: Thu, 22 May 2008 14:35:53 +0000
Subject: [PATCH] Make it utf8 compliant.

---
 library/translation.inc.php | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/library/translation.inc.php b/library/translation.inc.php
index 4f8cfe539..a47abde42 100644
--- a/library/translation.inc.php
+++ b/library/translation.inc.php
@@ -5,8 +5,11 @@ include_once(dirname(__FILE__) . '/sql.inc'); // fixes vulnerability with regist
 // this function is related to the interface/language module.
 
 function xl($constant,$mode='r',$prepend='',$append='') {
-	$lang_id=LANGUAGE;
-	$sql="SELECT * FROM lang_definitions JOIN lang_constants ON " .
+	$lang_id=LANGUAGE;
+	
+	// utf8 compliant
+    sqlQuery("SET NAMES utf8");
+    
	$sql="SELECT * FROM lang_definitions JOIN lang_constants ON " .
     "lang_definitions.cons_id = lang_constants.cons_id WHERE " .
     "lang_id='$lang_id' AND constant_name = '" .
     addslashes($constant) . "' LIMIT 1";
-- 
2.11.4.GIT