special character to csv in php

Question

here is current way i'm doing for generate csv file in php,

$path = $url . 'temp/' .$filename.'.csv';
   fputcsv($fp, $heders, ",");

        foreach ($new_data as $line) {
            fputcsv($fp, $line, ",");
        }
        fclose($fp);

here is problem which i have,

this is data i have in data set,

Brüel & Kjæ, Type 4226, S/N: 2433646

when generate csv file it's change to this,

BrÃ¼el & KjÃ¦, Type 4226, S/N: 2433646

i need to get exactly same character to csv. please help me to solve this issue :(

I think, you forget to set charset settings to UTF-8. – Jaydeep Pandya Dec 23 '16 at 06:37 — Jaydeep Pandya, Dec 23 '16 at 06:37
can you please tel me how to add ? – Ashan Dec 23 '16 at 06:40 — Ashan, Dec 23 '16 at 06:40
please review Chandresh's answer, he already replied . – Jaydeep Pandya Dec 23 '16 at 06:42 — Jaydeep Pandya, Dec 23 '16 at 06:42
it's not working bro same get same result :( – Ashan Dec 23 '16 at 06:49 — Ashan, Dec 23 '16 at 06:49
can you please update que as you tried utf8 in header. – Jaydeep Pandya Dec 23 '16 at 07:01 — Jaydeep Pandya, Dec 23 '16 at 07:01

score 1 · Answer 1 · answered Dec 23 '16 at 07:00

1

Try this, set UTF-8 before getting result for both mysqli query and header

1. $mysqli->set_charset("utf8");

and

2.  header('Content-type: application/csv');
    header('Content-Disposition: attachment; filename=' . $filename);
    header("Content-Transfer-Encoding: UTF-8");
    header('Pragma: no-cache');

answered Dec 23 '16 at 07:00

Jaydeep Pandya

825
1
10
25

im using mssql PDO connection. how to set charset to that ? – Ashan Dec 23 '16 at 07:02
@Ashan http://stackoverflow.com/questions/4361459/php-pdo-charset-set-names#answer-4361485 – Jaydeep Pandya Dec 23 '16 at 07:04
:( same not working i found this http://stackoverflow.com/questions/18744840/encoding-to-utf8-i-have-some-%C3%83-%C3%82 – Ashan Dec 23 '16 at 07:58

score 0 · Answer 2 · answered Dec 23 '16 at 06:40

0

Put this line of code at the top of the file in php,

header('Content-Type: text/html; charset=UTF-8');

Hope it will may helpful to resolve your issue.

Thanks.

answered Dec 23 '16 at 06:40

Chandresh M

3,808
1
24
48

special character to csv in php

2 Answers2