Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you the relevant system variables related to the mysql character set. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Character_set_system: the character set in which identifiers are stored, always utf8

Character_set_server: default character set for the server

Collation_server: default collation for the server

Character_set_database: the default character set for the database

Collation_database: default collation for the database

Character_set_client: the character set used by the client when sending sql statements to the server

Character_set_results: the character set used by the server to return the result set to the client

Character_set_connection: server variable when the server receives a statement string from the client, it converts the string from character_set_client to character_set_connection, and then uses the latter character set to process the statement

Collation_connection: suitable for comparing two text string values in a statement string

These are the mysql character set related system variables shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.