hulkkk Posted August 24, 2009 Share Posted August 24, 2009 Hello! So, I got this table on mysql storing kanjis. All works fine on php - store, view, edit, etc. I also got this function on internet to transform a mysql table in CSV, and works fine too! The problem is that when I open the csv on Excel, it doesn't read the kanjis, tho if I open on notepad it does. I've made a test and even normal accents like in "Japão" doesn't appear right. The table's collation is utf8_unicode_ci. Any idea? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/171660-problem-with-mysqlkanjicsv/ Share on other sites More sharing options...
hulkkk Posted August 25, 2009 Author Share Posted August 25, 2009 Anyone? Quote Link to comment https://forums.phpfreaks.com/topic/171660-problem-with-mysqlkanjicsv/#findComment-906199 Share on other sites More sharing options...
fenway Posted August 28, 2009 Share Posted August 28, 2009 Everything -- script, db connection, etc. -- need to be UTF-8 aware. Quote Link to comment https://forums.phpfreaks.com/topic/171660-problem-with-mysqlkanjicsv/#findComment-908344 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.