X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDBUpgrade2%2FBase.pm;h=00df6d2e8c201de9aa0fd6104b034821ee02a91a;hb=cb4847870dd086f46098ccd12dd03955766b2896;hp=34afeae54504abbb6dc1b319f7b626908cf27961;hpb=2536b717d4c7ce36e0bd2a85a6fba9e81d980955;p=kivitendo-erp.git diff --git a/SL/DBUpgrade2/Base.pm b/SL/DBUpgrade2/Base.pm index 34afeae54..00df6d2e8 100644 --- a/SL/DBUpgrade2/Base.pm +++ b/SL/DBUpgrade2/Base.pm @@ -11,6 +11,7 @@ use File::Basename (); use File::Copy (); use File::Path (); use List::MoreUtils qw(uniq); +use version; use Rose::Object::MakeMethods::Generic ( scalar => [ qw(dbh myconfig) ], @@ -57,8 +58,14 @@ sub db_query { sub db_errstr { my ($self, $handle) = @_; + # DBD::Pg before 2.16.1 doesn't set the UTF-8 flag for error + # messages even if the connection has UTF-8 enabled. Therefore we + # have to convert it to Perl's internal encoding ourselves. See + # https://rt.cpan.org/Public/Bug/Display.html?id=53854 + my $error = $handle ? $handle->errstr : $self->dbh->errstr; + return $error if version->new("$DBD::Pg::VERSION")->numify >= version->new("2.16.1")->numify; return Encode::decode('utf-8', $error); } @@ -256,8 +263,10 @@ be used. =item C Returns the last database from C<$handle> error message encoded in -Perl's internal encoding. The PostgreSQL DBD leaves the UTF-8 flag off -for error messages even if the C attribute is set. +Perl's internal encoding. The PostgreSQL DBD before 2.16.1 leaves the +UTF-8 flag off for error messages even if the C +attribute is set. For older versions the error string is already +encoded correctly and is left unchanged. C<$handle> is optional and can be one of three things: