791633 - can't display double-byte(chinese) words in the exported csv file

Status: UNCONFIRMED

(Bugzilla :: Reporting/Charting, defect)

Description

[David Lin]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1

Steps to reproduce:

1. use the advanced search function and got the list of open bugs
2. click the "CVS" link at the footer
3. open the downloaded csv file by excel 2010



Actual results:

see illegal characters since all contents are double-byte chinese words


Expected results:

display correct content when I open it by microsoft excel
please kindly add chr(65279) (UTF-8 with BOM ) when users download csv file.
-----------------
file name: Bugzilla/Template.pm
patch:

            # In CSV, quotes are doubled, and any value containing a quote or a
            # comma is enclosed in quotes.
            csv => sub
            {
                my ($var) = @_;
                $var =~ s/\"/\"\"/g;
                if ($var !~ /^-?(\d+\.)?\d*$/) {
                    $var = "\"$var\"";
                }
                return chr(65279).$var;
            } ,