Home >Database >phpMyAdmin >What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

coldplay.xixi
coldplay.xixiOriginal
2020-07-21 10:20:562441browse

MySQL Solution to garbled comments in phpmyadmin after inserting SQL statements: first query the sql statement, then add the statement [set names gbk] to the code to change the encoding; finally reopen it and the display will be correct.

What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

MySQL Solution to garbled comments in phpmyadmin after inserting SQL statements:

1. First query sql statement

What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

#2. I found that there was no problem with the SQL statement. It felt like it was a display encoding problem, so I used set names gbk to change the encoding and tried it.

What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

3. The display is OK

What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?

## Recommended tutorials:

phpmyadmin

The above is the detailed content of What should I do if mySQL comments are garbled in phpmyadmin after inserting SQL statements?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn