@@ -, +, @@ MySQL supports unicode, and will correctly flag utf8 data from the database if the "mysql_enable_utf8" is set in the connect options. my $schema = My::Schema->connection('dbi:mysql:dbname=test', $user, $pass, { mysql_enable_utf8 => 1} ); When set, a data retrieved from a textual column type (char, varchar, etc) will have the UTF-8 flag turned on if necessary. This enables character semantics on that string. You will also need to ensure that your database / table / column is configured to use UTF8. See Chapter 10 of the mysql manual for details. See DBD::mysql for further details. + mysql_enable_utf8 => 1, # REQUIRED to handle properly utf8 --- C4/Auth.pm | 3 ++- Koha/Database.pm | 5 ++++- 2 files changed, 6 insertions(+), 2 deletions(-) --- a/C4/Auth.pm +++ a/C4/Auth.pm @@ -984,8 +984,9 @@ sub checkauth { my $template_name = ( $type eq 'opac' ) ? 'opac-auth.tmpl' : 'auth.tmpl'; my $template = C4::Templates::gettemplate($template_name, $type, $query ); + my @branchloop= Koha::BusinessLogic::Branch->read()->all; $template->param( - branchloop => GetBranchesLoop(), + branchloop => \@branchloop, opaccolorstylesheet => C4::Context->preference("opaccolorstylesheet"), opaclayoutstylesheet => C4::Context->preference("opaclayoutstylesheet"), login => 1, --- a/Koha/Database.pm +++ a/Koha/Database.pm @@ -63,7 +63,10 @@ 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, # REQUIRED to handle properly utf8 + }); return $schema; } --