MySQL appears in the console in Chinese question mark question

Source: Internet
Author: User

Due to the re-installation of the Wampserver, the problems encountered before all will appear again, then today encountered in the MySQL console, in the table input Chinese data, but there is a question mark:

So this is related to coding, then we go to Wampserver to find the MySQL My.ini file, and then find [MySQL], [client], [mysqld] location, if not, you can manually add it, and add the relevant settings below the relevant, the code to edit into UTF8 just fine.

  

  

Then turn off the software to restart, I have a problem, that is, if I just restart the Wampserver software, the MySQL console again, and the code query, there is this problem:

Query statement: Show variables like ' char% ';

Can see, in addition to character-set-database, other coding is already a successful state of editing, and query the contents of the table, or garbled situation, only I wampserver software turned off and then re-query the code, it becomes this:

  

Then, when I query the contents of the table, the Chinese content will really show success:

Finally, solve the problem! Therefore, encounter problems, must not be impatient, you can Baidu query reasons, this problem will have a lot of people have met, remember their brains to think of their own to follow Baidu to try to solve, but did not solve their problems is what reason, do not be upset, slowly, believe that they will eventually solve the problem! Come on

                                                            

                                                          

END

MySQL appears in the console in Chinese question mark question

Related Article

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.