Geek asks and answers

Export Chinese characters from MySQL

I have a problem with Chinese characters when exporting query results to an XLS file. In my database, the Chinese character is stored as an encoded format such as

æâ€"°é‡Œç¨‹é›†å›¢

When I display this character on a web page, they are automatically converted to standard Chinese characters using the header function provided by PHP. But we want to extract Chinese characters for the XLS file from MySQL with the standard Chinese character.

+3
source share
1 answer

mplungjan advice is correct, but it is not so easy to do.
As a workaround, you can use iconv or mb_convert_encoding .

+2
source

More articles:


All Articles