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