[Koha-bugs] [Bug 11906] Bad display of utf-8 chars in Patron lists (Datatable)

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11906

--- Comment #8 from Galen Charlton <gmcharlt at gmail.com> ---
Actually... those MySQL configuration changes aren't necessary in order to fix
the problem.  Something like this suffices:

diff --git a/Koha/Database.pm b/Koha/Database.pm
index 12758bf..ef1e2db 100644
--- a/Koha/Database.pm
+++ b/Koha/Database.pm
@@ -55,7 +55,7 @@ sub _new_schema {
     my $db_passwd = $context->config("pass");
     my $schema    = Koha::Schema->connect(
         "DBI:$db_driver:dbname=$db_name;host=$db_host;port=$db_port",
-        $db_user, $db_passwd );
+        $db_user, $db_passwd, { mysql_enable_utf8 => 1 } );
     return $schema;
 }

This wouldn't be the final version of this patch, as we wouldn't want to pass
msyql_enable_utf8 to a Pg database, and we would have to make sure that binary
data (e.g., images stored in the database) don't get mangled, but I think
something like this patch would be more reliable.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.