How can php or js convert the transaction records csv files downloaded from Alipay into UTF8 codes?

this can see my other question: https://codeshelper.com/q/10.

.

the situation is that I want to download the transaction records in Alipay website in csv file format, and then import the data through my web application. But the table generated through datatables.net is shown in the following figure:

the downloaded csv file opens with notepad to show that it is ANSI, then saves the UTF8-encoded CSV file and then displays the Chinese language normally through the same datatable display. So I would like to ask if there is any good way to solve it under PHP or js.

Thank you.

Mar.10,2021

iconv ('GBK',' UTF-8//IGNORE', $content_of_csv);

see http://php.net/manual/zh/func.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e9b417-1845.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e9b417-1845.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?