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

This article editor for you a detailed introduction of the "MySQL database character set character how to use", the content is detailed, the steps are clear, the details are handled properly, I hope that this "MySQL database character set character how to use" article can help you solve doubts, the following follow the editor's ideas slowly in-depth, together to learn new knowledge.

Character set character

The character character is the general name of all kinds of words and symbols.

Character set character set is a collection of multiple characters

Common character sets:

ASCII character set

GB2312 character set

Unicode character set

2. Set the client character set-- set the client character set encoding set names gbk;-- view the character set encoding setting show variables like 'character_set_%' +-- +-+ | Variable_name | Value | +-+-+ | character_set_client | gbk | | character_set_connection | gbk | | character_ Set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | / usr/local/Cellar/mysql/8.0.16/share/mysql/charsets/ | + -insert Chinese characters insert into tb_teacher (name) Age) values ('Zhang San', 23)

There are three layers between MySQL and MySQLd:

The client passes data to the server client

The server returns the data to the client server

Connection collection between client and server

Variables:

Character_set_client client

Character_set_connection connection layer

Character_set_database database

Character_set_results result set

Modify the variable:

Set variable name = value;-- modify a single variable set character_set_client = gbk;-- setting character set set names gbk;-- is equivalent to set character_set_client = gbk; / / Let the server recognize the data passed by the client set character_set_connection = gbk; / / better help the awakening character set conversion between the client and the server set character_set_results = gbk / / tell the client server to read the data returned here. The article "how to use the character set character of MySQL database" has been introduced. If you want to master the knowledge points of this article, you still need to practice and use it before you can understand it. If you want to know more related articles, please 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.