@@ -, +, @@ connecting to databases one patron whose name or patron category description contains a non-ASCII character. be displayed correctly. Note that Apache will also log "list.pl: Wide character in print ...", but this is the lesser of two evils. passes when connect to a PostgreSQL database. --- Koha/Database.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) --- a/Koha/Database.pm +++ a/Koha/Database.pm @@ -53,9 +53,13 @@ sub _new_schema { my $db_port = $context->config("port") || ''; my $db_user = $context->config("user"); my $db_passwd = $context->config("pass"); + + my $db_opts = ($db_driver eq 'mysql') ? { mysql_enable_utf8 => 1 } : + ($db_driver eq 'Pg') ? { pg_enable_utf8 => 1 } : + { }; 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, $db_opts ); return $schema; } --