Export to CSV Encoding Problem

[codemator]

Hello All

I have a problem when trying to export date(in Czech) to CSV

 

Here is the code i am using

 

header("Content-type: application/force-download");

header('Content-Disposition: inline; filename="resultaat.csv"');

header("Content-Transfer-Encoding: Binary");

header("Content-length: ".strlen($sExcel));

  header('Content-Type: charset=utf-8');

header('Content-Type: application/octet-stream');

header('Content-Disposition: attachment; filename="resultaat.csv"');*

 

for($i=0;$i<count($pom);$i++){

          $out .=  $pom[$i]['msisdn'] ;

          $out .= ",";

          $out .= fixEncoding($pom[$i]['last']);

          $out .= ",";

          $out .= fixEncoding($pom[$i]['first']);

          $out .="\r\n";

          }

 

echo $out;

 

function fixEncoding($in_str)

{

    $cur_encoding = mb_detect_encoding($in_str) ;

  if($cur_encoding == "UTF-8")

    return $in_str;

  else

    return utf8_encode($in_str);

}

 

 

Please help me out ???

 

[Masna]

Well, why are you trying to encode everything with UTF-8? Is that the correct encoding for Czech?

[codemator]

BUT UTF-8 is working if i print it to browser,

Is there any thing wrong in doing that?