knutsford Posted November 16, 2017 Share Posted November 16, 2017 I am trying to download information from a MySQL database to excel one of of fields has emoji's in it but they are coming out as a ? in excel. How do I get them appear as an emoji in Excel? I am using header("Content-type: text/csv; charset=utf-8");header("Content-Encoding: utf-8"); Should it be something different to utf-8 to get it to work? Google just says use utf-8 Thanks Link to comment Share on other sites More sharing options...
requinix Posted November 16, 2017 Share Posted November 16, 2017 Do they appear if you open the file in a text editor (that you know supports emoji)? Link to comment Share on other sites More sharing options...
knutsford Posted November 16, 2017 Author Share Posted November 16, 2017 They are a ? in Wordpad Link to comment Share on other sites More sharing options...
knutsford Posted November 16, 2017 Author Share Posted November 16, 2017 ? in word as well Link to comment Share on other sites More sharing options...
requinix Posted November 17, 2017 Share Posted November 17, 2017 Make sure you're using the same charset everywhere: database, table, columns, connection, and code. If even one of them doesn't match then there could be problems. I assume you've verified that the emoji are stored properly in the database, right? You can see them normally? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.