View | Details | Raw Unified | Return to bug 20229
Collapse All | Expand All

(-)a/Koha/Database.pm (-2 / +3 lines)
Lines 69-80 sub _new_schema { Link Here
69
69
70
70
71
71
72
    my ( %encoding_attr, $encoding_query, $tz_query );
72
    my ( %encoding_attr, $encoding_query, $tz_query, $sql_mode_query );
73
    my $tz = $ENV{TZ};
73
    my $tz = $ENV{TZ};
74
    if ( $db_driver eq 'mysql' ) {
74
    if ( $db_driver eq 'mysql' ) {
75
        %encoding_attr = ( mysql_enable_utf8 => 1 );
75
        %encoding_attr = ( mysql_enable_utf8 => 1 );
76
        $encoding_query = "set NAMES 'utf8'";
76
        $encoding_query = "set NAMES 'utf8'";
77
        $tz_query = qq(SET time_zone = "$tz") if $tz;
77
        $tz_query = qq(SET time_zone = "$tz") if $tz;
78
        $sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'};
78
    }
79
    }
79
    elsif ( $db_driver eq 'Pg' ) {
80
    elsif ( $db_driver eq 'Pg' ) {
80
        $encoding_query = "set client_encoding = 'UTF8';";
81
        $encoding_query = "set client_encoding = 'UTF8';";
Lines 93-98 sub _new_schema { Link Here
93
            on_connect_do => [
94
            on_connect_do => [
94
                $encoding_query || (),
95
                $encoding_query || (),
95
                $tz_query || (),
96
                $tz_query || (),
97
                $sql_mode_query || (),
96
            ]
98
            ]
97
        }
99
        }
98
    );
100
    );
99
- 

Return to bug 20229