From 70e31cdfd01949235897035ad818e9a7b2d0c958 Mon Sep 17 00:00:00 2001 From: Mitch Jackson Date: Sun, 3 Mar 2019 19:26:41 -0500 Subject: [PATCH] RT# 82942 Force UTF8 client_encoding for Pg in RT::Handle --- rt/lib/RT/Handle.pm | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/rt/lib/RT/Handle.pm b/rt/lib/RT/Handle.pm index f0bce38c1..35d218c1d 100644 --- a/rt/lib/RT/Handle.pm +++ b/rt/lib/RT/Handle.pm @@ -138,6 +138,11 @@ sub Connect { ($version) = $version =~ /^(\d+\.\d+)/; $self->dbh->{pg_server_prepare} = 0 if $version > 9.1; #and we're using a deb-7 version DBD::Pg? $self->dbh->do("SET bytea_output = 'escape'") if $version >= 9.0; + + # Force UTF8, even when database encoding is not UTF8 + # DBD::Pg used to do this for us prior to v3 + $self->dbh->do('SET client_encoding TO UTF8;'); + $self->dbh->{pg_enable_utf8} = -1; } -- 2.11.0