Garbled characters problem when php exports data in excel's .csv format

Solutions to garbled characters when php exports Excel's .csv format data: 1. Change the encoding, you can try [UTF-8, GBK, GB2312] and other encoding formats; 2. Modify the file encoding problem and convert the file The format is changed to [UTF-8] with BOM format.

Solution to garbled characters when php exports Excel’s .csv format data:

1, header('Content-Encoding: XXXX');

It may be an encoding problem: you can try UTF-8, GBK, GB2312, and other encoding formats

2. It may be File encoding problem, although UTF-8 is not recommended to bring BOM, but the exported excel is a Microsoft product, so the file format needs to be changed to, UTF-8 has BOM format.

Related learning recommendations: PHP programming from entry to proficiency

The above is the detailed content of Garbled characters problem when php exports data in excel's .csv format. For more information, please follow other related articles on the PHP Chinese website!