Mysql comments are how to solve garbled codes in Chinese.

Editor to share with you mysql comments is how to solve Chinese garbled, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Mysql comments are the solution to Chinese garbled code: first use the "show variables like" command to check the character set settings of the database and the server, and then execute the statement "set collation_server=utf8_general_ci;".

Mysql table comments garbled

problem

Execution statement: alter table TABLE_XXX comment 'Chinese number'

Results: use information_schema

The comment of select * from TABLES where TABLE_SCHEMA='mydb' and TABLE_NAME='TABLE_XXX'TABLE_XXX is garbled

Check the system

Use show variables like "% colla%"; show varables like "% char%"; these two commands to view the database and server character set settings

Modify

Set collation_server=utf8_general_ci;set collation_connection=utf8_general_ci; above is the mysql comments are all the content of how to solve Chinese garbled, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!