I am having some problems with the phpMyAdmin Export function when it comes to foreign characters (primarily Chinese). The default encoding is UTF-8. When I browse strings through phpMyAdmin, the characters are correct. I embed data in MySQL via PHP using encoding UTF-8.
Everything seems to be fine. I get the wrong output when I use phpMyAdmin to export, be it CSV, .sql, JSON, whatever. Looking at exported files in a plain text encoded text editor UTF-8seems to work out like this, too, so I guess it could be due to my phpMyAdmin export configuration? Has anyone else ever experienced this?
真棒男人酷 真棒男人酷
becomes
真棒ç"·äººé…· 真棒ç"·äººé…·
Thanks a lot SO
source
share