How to generate csv file with default UTF-8 encoding using php

Question

By fetching data from mysql table i am generating csv file and uploading to some ftp folder. But other person using this csv file from ftp side says that it is in ANSI encoding. How can i change that to UTF-8 encoding? For this I am using the below code.

   header('Content-Encoding: utf-8');
   header('Content-Type: text/csv; charset=utf-8');
    $fh1 = fopen($current_csv_name, 'w+');
    foreach($csv_data as $curl_response)
    {
        fputs($fh1, implode($curl_response, ';')."\n");
    }
    fclose($fh1);

When i download the file and open in notepad and click on save as it is always showing Encoding as ASNI. Where i am doing wrong? Any help would be greatly appreciated.

If you explicitly force an application (Notepad++ or whatever) to treat the file as UTF-8, does the content appear correctly? Then it's UTF-8. If the content consists only of basic ASCII characters then UTF-8 is indistinguishable from virtually all other encodings, and Notepad et al. are merely guessing incorrectly. — deceze
– deceze ♦, Commented Jun 12, 2017 at 13:21

Osuwariboy · Accepted Answer · 2017-06-12 13:13:17Z

3

I believe you need to add the BOM (Byte order Mark) at the beginning of the file, otherwise, the filesystem will always assume your charset to be ANSI by default. Try doing this:

header('Content-Encoding: utf-8');
header('Content-Type: text/csv; charset=utf-8');
$fh1 = fopen($current_csv_name, 'w+');

$bom = chr(0xEF) . chr(0xBB) . chr(0xBF);
fputs($fh1, $bom);

foreach($csv_data as $curl_response)
{
    fputs($fh1, implode($curl_response, ';')."\n");
}
fclose($fh1);

answered Jun 12, 2017 at 13:13

Osuwariboy

1,3851 gold badge14 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WTFranklin Over a year ago

This seems to be the case. I tried with and without the BOM, but the CSV only showed utf-8 characters with it included.

Benjamin · Accepted Answer · 2023-09-22 14:24:38Z

0

Assuming your data is UTF in your DB, then you need to modify how your produce the document.

In my code I replace a bare echo with a modified one using iconv:

// echo $csv;
echo iconv("UTF-8", "ISO-8859-2", $csv);

answered Sep 22, 2023 at 14:24

Benjamin

1961 gold badge3 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to generate csv file with default UTF-8 encoding using php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related