MySQL garbled problem _php tutorial

Source: Internet
Author: User
MySQL garbled file

Move the server this afternoon; the transfer data was killed. Because the data is upgraded to a higher version through MySQL's low version, there are many problems in the relocation process.

Because the default character set used to start the database is a bit of a problem with gb2312 upgraded MySQL, and finally the setchar=gb2312 of the data is taken out;

Then setchar the text set depends on your MySQL my.cnf when the default character set file is used, if the default is gb2312 no way you will setchar remove your character or gb2312

So you can change setchar=gb2312 to setchar=latin1. The default startup character set for my.cnf files is removed from the new startup MySQL

http://www.bkjia.com/PHPjc/508510.html www.bkjia.com true http://www.bkjia.com/PHPjc/508510.html techarticle MySQL garbled file this afternoon moved the server; the transfer data was killed because the data was upgraded to a higher version through MySQL's low version;

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.