Attachment 45353 Details for Bug 15290 – Bug 15290: SQL reports headers encoding problem

[patch] Bug 15290: SQL reports headers encoding problem

Bug-15290-SQL-reports-headers-encoding-problem.patch (text/plain), 1.64 KB, created by Tomás Cohen Arazi (tcohen) on 2015-12-03 14:29:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2015-12-03 14:29:27 UTC

Size: 1.64 KB

patch

obsolete

>From c1ca0fa109058c414b39c3f7789ff1c1d074e159 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@gmail.com>
>Date: Thu, 3 Dec 2015 11:23:54 -0300
>Subject: [PATCH] Bug 15290: SQL reports headers encoding problem
>
>To test:
>
>- Create an SQL report with column names containing UTF characters
>- Run the report
>=> FAIL: The column names are double encoded
>- Export the report
>=> FAIL: The column names are double encoded in the exported file
>- Apply the patch
>- Re-run the report (reload works)
>=> SUCCESS: Encoding correct
>- Export the report
>=> SUCCESS: Encoding correct
>- Sign off :-D
>---
> reports/guided_reports.pl | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/reports/guided_reports.pl b/reports/guided_reports.pl
>index cbdecda..361c518 100755
>--- a/reports/guided_reports.pl
>+++ b/reports/guided_reports.pl
>@@ -771,7 +771,7 @@ elsif ($phase eq 'Run this report'){
>             unless ($sth) {
>                 die "execute_query failed to return sth for report $report_id: $sql";
>             } else {
>-                my $headers= header_cell_loop($sth);
>+                my $headers = header_cell_loop($sth);
>                 $template->param(header_row => $headers);
>                 while (my $row = $sth->fetchrow_arrayref()) {
>                     my @cells = map { +{ cell => $_ } } @$row;
>@@ -948,7 +948,7 @@ sub header_cell_values {
> 
> # pass $sth, get back a TMPL_LOOP-able set of names for the column headers
> sub header_cell_loop {
>-    my @headers = map { +{ cell => $_ } } header_cell_values (shift);
>+    my @headers = map { +{ cell => decode('UTF-8',$_) } } header_cell_values (shift);
>     return \@headers;
> }
> 
>-- 
>2.6.3

Actions: View | Diff | Splinter Review

Attachments on bug 15290: 45353 | 45384 | 45385 | 45456 | 45457 | 45501 | 45502