Tag Archives: phpmyadmin

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

mysql: How to copy a database in phpMyAdmin

How to copy a database in phpMyAdmin This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin. Begin by accessing phpMyAdmin via cPanel . Select the database you wish to copy (by clicking on the database from … Continue reading

Posted in database | Tagged , | Comments Off on mysql: How to copy a database in phpMyAdmin

mysql: Change character encoding for database and tables

http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 Use the ALTER DATABASE and ALTER TABLE commands. ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; If not possible, Export structure and data with phpmyadmin Custom – display all … Continue reading

Posted in database | Tagged , | Comments Off on mysql: Change character encoding for database and tables