How to Ensure UTF8 Characters with fputcsv in PHP

Even when you config php.ini to output UTF8 characters for your PHP instance, you still need to ensure the fputcsv() function is outputting UTF8 characters

By Rob Johnson

Mon Nov 25 2019

dev php

I was working on a project where I transform data, create and load a CSV for another system to process. The issue was non-conforming characters were breaking the endpoint system. I ensured that my php.ini configuration had the UTF8 character set defined as default, however the output from fputcsv() was still outputting non-UTF8 characters.

I found the a Stack Overflow conversation and saw that the fix was to issue the following definitions in the fputcsv() function.

fprintf($df, chr(0xEF).chr(0xBB).chr(0xBF));

The line fprintf($df, chr(0xEF).chr(0xBB).chr(0xBF)); writes file header for correct encoding.

Thanks goes to Hardy.

commerce 4 seo 3 productivity 1 dev 15 sql 1 tutorial 2 javascript 7 git 2 php 3 analytics 3 projects 3 ux 1 teams 1 mobile 1