hello monks I am using dbix::dump data from database Which is in utf-8. (When saving as excel or csv) The column data which is in utf8 is displaying as ???????. Is there any way i can dump data in proper format. 


 my $sql1 = "select deptid,to_char(a.epfno) epfno,a.ename ename,desig,
+decode(b.status,'P','उपस्थि&#2340
+;','A','अवकाश','D','प्&#235
+2;तिनियुक्त&#23
+67;')
status,b.rmk from Atnd_emp_mast a,Atnd_position b where repoid=1 and I
+SACTIVE=0 and a.epfno=b.epfno and SUMM_HOD_FLAG=1 
and ATTEN_DT=to_date('17-12-2020','DD-MM-YYYY') order by SUMM_SORTID";
+ 
                    $sth =$dbh->prepare($sql1);
                    $sth->execute();
                    $out = DBIx::Dump->new('format' => excel,   # exce
+l or csv
                        'output' => $f1, # file to save as
                        'sth'    => $sth);
                    $out->dump();
                    print "Report Generated with file name $f1 \n";
                    $f2 = join".",$f1,"xls";
                    system "copy $f1 $f2";
                    print "$f2 \n";

[download]

Out put is coming as 

DEPTID    EPFNO    ENAME    DESIG    STATUS    RMK
19    3346927            (...)    
+‰पस्थित    
9    5222958            ()
+    प्रतिनियु•्ति    
10    2870266           ( ..)    ‰
+स्थित    
7    2874318            (   )    &#1
+37;पस्थित    
9    2864045            (  
+ )    ‰पस्थित    
15    4415744           (    ) 
+   …व•ाश    
17    2860538                 ‰पस
+थित

[download]

In reply to Dump data from unicode database by sachin raj aryan

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.