mysql garbled problem_PHP tutorial

Garbled files of mysql

I moved the server this afternoon; the transferred data was destroyed because the data was upgraded from a low version of mysql to a high version; many problems occurred during the relocation process question.

Because the default character set used when creating the database is gb2312, there is a problem with the upgraded mysql; finally, remove all setchar=gb2312 from the exported data;

Then setchar the text The set depends on what is the default character set file used when your mysql my.cnf is started; if the default is gb2312, there is no way you can remove the setchar and the characters you get will still be gb2312

, so you can Change setchar=gb2312 to setchar=latin1. If that doesn't work, remove the default startup character set of the my.cnf file and restart mysql

http://www.bkjia.com/PHPjc/508510.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/508510.htmlTechArticleThe garbled file of mysql was moved to the server this afternoon; the transferred data was destroyed because the data was passed through a lower version of mysql Upgraded to a higher version; many problems occurred during the relocation process...