Home  >  Article  >  Backend Development  >  Garbled characters problem when php exports data in excel's .csv format

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

coldplay.xixi
coldplay.xixiOriginal
2020-07-14 09:56:372262browse

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.

Garbled characters problem when php exports data in excel's .csv 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.

Garbled characters problem when php exports data in excels .csv 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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn