phpmyadmin: mysql export Simplified Chinese utf csv gibberish text issue

The database collation is utf8_unicode_ci but can’t guarantee the Chinese text encoding was 100% correct during data entry (may have mixed with Traditional Chinese?)

When we use the usual route in phpmyadmin to export the data to .csv, the generated .csv file doesn’t show the Simplified Chinese text properly. Same issue when exporting to Microsoft .csv

Manual workaround: Export the data to .csv but select “View output as text”. This somehow generates the data with the Simplified Chinese text correctly.

Select all, copy and paste to your Microsoft Excel and… problem solved.

This entry was posted in database, troubleshoot and tagged , , , , . Bookmark the permalink.