Tag Archives: csv

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 … Continue reading

Posted in database, troubleshoot | Tagged , , , , | Comments Off on phpmyadmin: mysql export Simplified Chinese utf csv gibberish text issue

CSV to SQL Converter

Microsoft excel can’t seem to export csv with double quotes anymore =_=, can’t import csv directly using phpmyadmin. Found this really site that helps to make the conversion from csv to mysql statements. http://www.convertcsv.com/csv-to-sql.htm

Posted in database | Tagged , | Comments Off on CSV to SQL Converter