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 Quote 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)? Quote 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 Quote 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 Quote 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.