1
I’m trying to export some records from the Mysql database to Excel, But when you open the spreadsheet where there’s an accentuation, there’s a sign that I can sort this out?
0No answers
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
What is the charset of the database and your php file?
– rray
The problem is coding. Probably your base is in
UTF-8and Excel always usesISO-8859-1. I can’t remember if you have any Mysql client settings to convert the data, but you might try using maybe Notepad++ to convert the encoding before putting in Excel.– utluiz
Put the code that generates the excel file.
– rray